OCI: unable to create book or collection

[ddevadat]

When attempting to create a book...we get the below error in the content pods

2024-04-30 03:38:48,331 CSPMetaUtil ::: updateAbsolutePath util.Map[String, AnyRef] ::: data before url replace :: {ownershipType=[Ljava.lang.String;@79a340de, code=org.sunbird.MfYrYo, year=2011, credentials={"enabled":"No"}, channel=0140405158529433600, organisation=[Ljava.lang.String;@3d77c22a, description=Enter description for TextBook, language=[Ljava.lang.String;@474c4735, mimeType=application/vnd.ekstep.content-collection, idealScreenSize=normal, createdOn=2024-04-30T03:38:47.219+0000, primaryCategory=Digital Textbook, contentDisposition=inline, contentEncoding=gzip, lastUpdatedOn=2024-04-30T03:38:47.748+0000, lockKey=f268b20e-e152-4d2c-8298-4fa6e318c30e, generateDIALCodes=No, dialcodeRequired=No, contentType=TextBook, trackable={"enabled":"No","autoBatch":"No"}, creator=creator, audience=[Ljava.lang.String;@10b0b2e6, createdFor=[Ljava.lang.String;@73f6b59e, lastStatusChangedOn=2024-04-30T03:38:47.219+0000, os=[Ljava.lang.String;@70134f58, visibility=Default, consumerId=984706fe-b15d-4e49-b62e-b293a8c6708b, discussionForum={"enabled":"No"}, mediaType=content, osId=org.ekstep.quiz.app, version=2, versionKey=1714448327748, license=CC BY 4.0, idealScreenDensity=hdpi, framework=NCF, createdBy=5227f9e9-cf88-44c4-b5a3-fd5c3f9eb2b6, compatibilityLevel=1, userConsent=Yes, name=Sample Book , resourceType=Book, status=Draft}
2024-04-30 03:38:48,331 CSPMetaUtil ::: updateAbsolutePath util.Map[String, AnyRef] ::: updateAbsolutePath returnData :: {ownershipType=[Ljava.lang.String;@79a340de, code=org.sunbird.MfYrYo, year=2011, credentials={"enabled":"No"}, channel=0140405158529433600, organisation=[Ljava.lang.String;@3d77c22a, description=Enter description for TextBook, language=[Ljava.lang.String;@474c4735, mimeType=application/vnd.ekstep.content-collection, idealScreenSize=normal, createdOn=2024-04-30T03:38:47.219+0000, primaryCategory=Digital Textbook, contentDisposition=inline, contentEncoding=gzip, lastUpdatedOn=2024-04-30T03:38:47.748+0000, lockKey=f268b20e-e152-4d2c-8298-4fa6e318c30e, generateDIALCodes=No, dialcodeRequired=No, contentType=TextBook, trackable={"enabled":"No","autoBatch":"No"}, creator=creator, audience=[Ljava.lang.String;@10b0b2e6, createdFor=[Ljava.lang.String;@73f6b59e, lastStatusChangedOn=2024-04-30T03:38:47.219+0000, os=[Ljava.lang.String;@70134f58, visibility=Default, consumerId=984706fe-b15d-4e49-b62e-b293a8c6708b, discussionForum={"enabled":"No"}, mediaType=content, osId=org.ekstep.quiz.app, version=2, versionKey=1714448327748, license=CC BY 4.0, idealScreenDensity=hdpi, framework=NCF, createdBy=5227f9e9-cf88-44c4-b5a3-fd5c3f9eb2b6, compatibilityLevel=1, userConsent=Yes, name=Sample Book , resourceType=Book, status=Draft}
com.datastax.driver.core.exceptions.InvalidQueryException: Undefined column name relational_metadata
	at com.datastax.driver.core.Responses$Error.asException(Responses.java:181)
	at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:215)
	at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:228)
	at com.datastax.driver.core.RequestHandler.access$2600(RequestHandler.java:62)
	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:1005)
	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:808)
	at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1233)
	at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1151)
	at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:323)
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:297)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
	at com.datastax.driver.core.InboundTrafficMeter.channelRead(InboundTrafficMeter.java:38)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1408)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:930)
	at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:796)
	at io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:427)
	at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:328)
	at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:905)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.base/java.lang.Thread.run(Thread.java:834)
Exception occurred - class :com.datastax.driver.core.exceptions.InvalidQueryException with message :Undefined column name relational_metadata
2024-04-30 03:38:48,335 {"eid":"LOG","ets":1714448328335,"ver":"3.0","mid":"LP.1714448328335.9e02439f-3d21-48ee-bba1-ba496c8ec0d5","actor":{"id":"org.sunbird.learning.platform","type":"System"},"context":{"channel":"in.ekstep","pdata":{"id":"dev.PNG-EdPortal.portal","pid":"","ver":"1.0"},"env":"content","sid":"m2iah8lkDELPQaxx-rkT9A1G9Rcl-unZ","did":"1a8ae202d3128abd0dbe05fb70f7b911"},"edata":{"level":"INFO","type":"api_access","message":"","params":[{"duration":8},{"protocol":"http"},{"size":309},{"method":"GET"},{"uip":"10.244.0.56"},{"url":"/content/v3/hierarchy/do_114044760696545280137?mode=edit"},{"status":500}]},"syncts":1714448328335}

[vinukumar-vs]

@pallakartheekreddy Any idea what can be causing this issue while creation of Book.

@ddevadat Can you please share the Create CURL command while inspecting the network tab (while creating the book). Just to know what data is going into the payload.

The reason for this i am expecting in Cassandra DB where content Hierarchy will store, doesn't have the table columns setup properly.
https://github.com/Sunbird-Knowlg/knowledge-platform/blob/master/schemas/collection/1.0/config.json

@mohitga @gandham-santhosh @amitpriyadarshi

[gandham-santhosh]

@ddevadat these columns in the other tables might have been already created.
Are you seeing any error while creating book now?

[ddevadat]

i am getting a proper editor now. Is there a document which explains the workflow or data entries to be made for creating book and generating a qr code

[vinukumar-vs]

@ddevadat We have very high level documentation on the features of Collection-Editor.
https://knowlg.sunbird.org/learn/product-and-developer-guide/editors/collection-editor-v2/features

See if it can help you to create the Book.

@ashokreddy1208 Is there any test scenarios or reference which can help to create the textbook

@mohitga @pallakartheekreddy

[ashokreddy1208]

@ddevadat please find recorded session for creation of the textbook, this might help you.

Link: https://drive.google.com/file/d/1QrZ3nYnjj8mR3VF24l_ZQlqCXoCc0AbG/view?usp=sharing

cc @vinukumar-vs @mohitga @pallakartheekreddy

[ddevadat]

Thanks. I have managed to create the book..but facing the issue described here
https://github.com/orgs/Sunbird-Ed/discussions/718#discussioncomment-9323465

[ddevadat]

i am facing the similar issue found in https://github.com/orgs/Sunbird-Knowlg/discussions/203#discussioncomment-9291908
i created a bucket named dial .
Is this dial bucket supposed to be private or public bucket?

[ddevadat]

So i have managed to add a book. However some problem remains, where i need help.

1. How to get the QR code image of the book. e.g When i search the book i see it in the content list but i am not able see any QR code.
2. I have downloaded the QR images at the time of book creation. So if i search with QR code number, i get the output. e.g
   e.g my qr code is H3Y2V7 and if i search with this , i am getting the book in the result.

however if i scan the qr code, its calling https://XXXXXXXX/dial/H3Y2V7
This gives a page like this

The book i created is a DigitalTextbook, but looks like the dial code curl is searching in Textbook.

curl 'https://XXXXXXXXXXXX/api/data/v1/dial/assemble' \
  -H 'Accept: application/json' \
  -H 'Accept-Language: en-GB,en-US;q=0.9,en;q=0.8' \
  -H 'Connection: keep-alive' \
  -H 'Content-Type: application/json' \
  -H 'Cookie: connect.sid=s%3Ab_nB0WMZab5hd0jNZkg9M1JlSrNkyoOG.iMhmLf6qaHkaAtYimv%2FiS0QtF%2BKNHL%2BfLbIUG75NBJc' \
  -H 'Origin: https://XXXXXXXXXXXX' \
  -H 'Referer: https://XXXXXXXXXXXX/get/dial/T5S3J3?source=scan' \
  -H 'Sec-Fetch-Dest: empty' \
  -H 'Sec-Fetch-Mode: cors' \
  -H 'Sec-Fetch-Site: same-origin' \
  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36' \
  -H 'X-App-Id: dev.PNG-EdPortal.portal' \
  -H 'X-App-Version: 6.0.0' \
  -H 'X-Channel-Id: 0140405158529433600' \
  -H 'X-Device-ID: 2af27a617e15c92253a4476e76124307' \
  -H 'X-Org-code: 0140405158529433600' \
  -H 'X-Request-ID: 0951d305-1d87-4126-9d2d-2b49f40c0297' \
  -H 'X-Session-ID: 3ab820fe-cc55-43ba-9365-77aa549ade7a' \
  -H 'X-Source: web' \
  -H 'X-msgid: 0951d305-1d87-4126-9d2d-2b49f40c0297' \
  -H 'sec-ch-ua: "Google Chrome";v="123", "Not:A-Brand";v="8", "Chromium";v="123"' \
  -H 'sec-ch-ua-mobile: ?0' \
  -H 'sec-ch-ua-platform: "macOS"' \
  -H 'ts: 2024-05-06T11:43:53+10:00' \
  --data-raw '{"request":{"source":"web","name":"DIAL Code Consumption","filters":{"dialcodes":"T5S3J3","contentType":["Collection","TextBook","TextBookUnit","Resource","Course"]},"userProfile":{}}}'

Response

{
    "id": "api.dial.assemble",
    "ver": "v1",
    "ts": "2024-05-06 01:43:53:593+0000",
    "params": {
        "resmsgid": null,
        "msgid": "0951d305-1d87-4126-9d2d-2b49f40c0297",
        "err": "PAGE_NOT_EXIST",
        "status": "PAGE_NOT_EXIST",
        "errmsg": "Requested page does not exist."
    },
    "responseCode": "RESOURCE_NOT_FOUND",
    "result": {}
}

[vinukumar-vs]

@ddevadat For the above comment, The curl command is right. "Primary Category" name is given as "Digital Textbook" but the CURL command is looking for "ContentType" as "TextBook" which is right.

@pallakartheekreddy @rajeevsathish and @amitpriyadarshi Can you check who is returning the response with "err": "PAGE_NOT_EXIST"

The book i created is a DigitalTextbook, but looks like the dial code curl is searching in Textbook.

[ddevadat]

while searching this issue ...found this
https://github.com/orgs/Sunbird-Ed/discussions/462

i tried searching db

cqlsh:sunbird> select * from page_management where name='DIAL Code Consumption' ALLOW FILTERING;

 id | appmap | created_date | createdby | createddate | name | organisationid | portalmap | updated_date | updatedby | updateddate
----+--------+--------------+-----------+-------------+------+----------------+-----------+--------------+-----------+-------------

(0 rows)

[amitpriyadarshi]

@ddevadat it seems dial assemble page and section are not created. please refer link.

• create page section by passing respective query.
• then create page object using respective payload.

cc: @vinukumar-vs

[ddevadat]

Is there any sample payload available example available?

[amitpriyadarshi]

@ddevadat
Request Payload for page section:

    "request": {
        "name": "Linked Content",
        "searchQuery": {
            "request": {
                "facets": [
                    "language",
                    "grade",
                    "domain",
                    "contentType",
                    "primaryCategory",
                    "subject",
                    "medium"
                ],
                "filters": {
                    "primaryCategory": [
                        "Digital Textbook",
                        "Textbook Unit",
                        "Course",
                        "Explanation Content",
                        "Content Playlist"
                    ],
                    "contentType": [
                        "Collection",
                        "TextBook",
                        "TextBookUnit",
                        "Resource",
                        "Course"
                    ],
                    "status": [
                        "Live"
                    ],
                    "compatibilityLevel": {
                        "max": 4,
                        "min": 1
                    },
                    "visibility": []
                },
                "mode": "collection",
                "userProfile": {}
            },
            "limit": 10,
            "sort_by": {
                "lastUpdatedOn": "desc"
            }
        },
        "sectionDataType": "Content",
        "display": {
            "name": {
                "en": "Linked Content"
            }
        }
    }
}

Request Payload for page:

    "request": {
        "name": "DIAL Code Consumption",
        "organisationId": "NA",
        "portalMap": [
            {
                "id": {{newly_created_page_section_id}},
                "index": 1,
                "group": 1
            }
        ],
        "appMap": [
            {
                "id": {{newly_created_page_section_id}},
                "index": 1,
                "group": 1
            }
        ]
    }
}

cc: @vinukumar-vs

[ddevadat]

Page read response

{
    "id": "api.page.read",
    "ver": "v1",
    "ts": "2024-05-07 05:47:12:546+0000",
    "params": {
        "resmsgid": null,
        "msgid": "930ce4b2-2a84-41a8-bbc8-eb7da42479e5",
        "err": null,
        "status": "success",
        "errmsg": null
    },
    "responseCode": "OK",
    "result": {
        "page": {
            "organisationId": "0140405158529433600",
            "name": "DIAL Code Consumption",
            "portalSections": [
                {
                    "oldUpdatedDate": null,
                    "display": "{\"name\":{\"en\":\"Linked Content\"}}",
                    "alt": null,
                    "description": null,
                    "index": "1",
                    "oldCreatedDate": null,
                    "sectionDataType": "Content",
                    "imgUrl": null,
                    "searchQuery": "{\"request\":{\"facets\":[\"language\",\"grade\",\"domain\",\"contentType\",\"primaryCategory\",\"subject\",\"medium\"],\"filters\":{\"primaryCategory\":[\"Digital Textbook\",\"Textbook Unit\",\"Course\",\"Explanation Content\",\"Content Playlist\"],\"contentType\":[\"Collection\",\"TextBook\",\"TextBookUnit\",\"Resource\",\"Course\"],\"status\":[\"Live\"],\"compatibilityLevel\":{\"max\":4,\"min\":1},\"visibility\":[]},\"mode\":\"collection\",\"userProfile\":{}},\"limit\":10,\"sort_by\":{\"lastUpdatedOn\":\"desc\"}}",
                    "name": "Linked Content",
                    "id": "0140495851849891840",
                    "dataSource": null,
                    "dynamicFilters": null,
                    "status": 1,
                    "group": "1"
                }
            ],
            "id": "0140495892056391681",
            "appSections": [
                {
                    "oldUpdatedDate": null,
                    "display": "{\"name\":{\"en\":\"Linked Content\"}}",
                    "alt": null,
                    "description": null,
                    "index": "1",
                    "oldCreatedDate": null,
                    "sectionDataType": "Content",
                    "imgUrl": null,
                    "searchQuery": "{\"request\":{\"facets\":[\"language\",\"grade\",\"domain\",\"contentType\",\"primaryCategory\",\"subject\",\"medium\"],\"filters\":{\"primaryCategory\":[\"Digital Textbook\",\"Textbook Unit\",\"Course\",\"Explanation Content\",\"Content Playlist\"],\"contentType\":[\"Collection\",\"TextBook\",\"TextBookUnit\",\"Resource\",\"Course\"],\"status\":[\"Live\"],\"compatibilityLevel\":{\"max\":4,\"min\":1},\"visibility\":[]},\"mode\":\"collection\",\"userProfile\":{}},\"limit\":10,\"sort_by\":{\"lastUpdatedOn\":\"desc\"}}",
                    "name": "Linked Content",
                    "id": "0140495851849891840",
                    "dataSource": null,
                    "dynamicFilters": null,
                    "status": 1,
                    "group": "1"
                }
            ]
        }
    }
}

Page Section read response

{
    "id": "api.page.section.read",
    "ver": "v1",
    "ts": "2024-05-07 05:49:34:316+0000",
    "params": {
        "resmsgid": null,
        "msgid": "b2e0f1ff-dab3-4572-9ddb-1544c6c443f2",
        "err": null,
        "status": "success",
        "errmsg": null
    },
    "responseCode": "OK",
    "result": {
        "section": {
            "updatedBy": null,
            "oldUpdatedDate": null,
            "display": "{\"name\":{\"en\":\"Linked Content\"}}",
            "alt": null,
            "description": null,
            "oldCreatedDate": null,
            "updatedDate": null,
            "sectionDataType": "Content",
            "imgUrl": null,
            "createdDate": "2024-05-07 04:43:34:879+0530",
            "createdBy": "2ba5b169-2596-4b55-a06d-633cd740e044",
            "searchQuery": "{\"request\":{\"facets\":[\"language\",\"grade\",\"domain\",\"contentType\",\"primaryCategory\",\"subject\",\"medium\"],\"filters\":{\"primaryCategory\":[\"Digital Textbook\",\"Textbook Unit\",\"Course\",\"Explanation Content\",\"Content Playlist\"],\"contentType\":[\"Collection\",\"TextBook\",\"TextBookUnit\",\"Resource\",\"Course\"],\"status\":[\"Live\"],\"compatibilityLevel\":{\"max\":4,\"min\":1},\"visibility\":[]},\"mode\":\"collection\",\"userProfile\":{}},\"limit\":10,\"sort_by\":{\"lastUpdatedOn\":\"desc\"}}",
            "name": "Linked Content",
            "id": "0140495851849891840",
            "dataSource": null,
            "dynamicFilters": null,
            "status": 1
        }
    }
}

[ddevadat]

i tried creating a new book , and same behavior when i try to scan the qr code

[amitpriyadarshi]

@ddevadat which version of lms service(course-service) is deployed?

[amitpriyadarshi]

@ddevadat please restart lms service and try.
cc: @vinukumar-vs

[ddevadat]

lms build details:
repo: https://github.com/ocisunbird/sunbird-course-service.git
branch: oc-5.1.0-JAPACCOE-2845-release-5.0.0_RC2_DU406-delta

already restarted lms.

[amitpriyadarshi]

@ddevadat can you share request payload you triggered for creating page object?

[ddevadat]

page create payload

{    "request": {
        "name": "DIAL Code Consumption",
        "organisationId": "0140405158529433600",
        "portalMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ],
        "appMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ]
    }
}

[amitpriyadarshi]

@ddevadat sorry I mentioned only payload, I am expecting complete curl. What is passed in header as well.

[ddevadat]

curl --location 'https://XXXXXXX//api/data/v1/page/create' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer XXXXX' \
--header 'x-authenticated-user-token: XXXXXX' \
--data '{    "request": {
        "name": "DIAL Code Consumption",
        "organisationId": "0140405158529433600",
        "portalMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ],
        "appMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ]
    }
}'

[amitpriyadarshi]

@ddevadat whatever request payload I shared for page creation, it was having"organisationId": "NA". Is there any specific reason you passed "organisationId": "0140405158529433600"?

Can you try to create a page using:

curl --location 'https://XXXXXXX//api/data/v1/page/create' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer XXXXX' \
--header 'x-authenticated-user-token: XXXXXX' \
--data '{    "request": {
        "name": "DIAL Code Consumption",
        "portalMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ],
        "appMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ]
    }
}'

and then restart the lms service. Also share the read response for respective page id, dial assemble api response and cassandra entry for below query.

select * from page_management where name='DIAL Code Consumption' ALLOW FILTERING;

[ddevadat]

The curl command for page creation didnt work without any org id

i already restarted lms service. Below is the entry in the table

cqlsh:sunbird> select * from page_management where name='DIAL Code Consumption' ALLOW FILTERING;

 id                  | appmap                                                 | created_date                    | createdby                            | createddate | name                  | organisationid      | portalmap                                              | updated_date | updatedby | updateddate
---------------------+--------------------------------------------------------+---------------------------------+--------------------------------------+-------------+-----------------------+---------------------+--------------------------------------------------------+--------------+-----------+-------------
 0140495892056391681 | [{"id":"0140495851849891840","index":"1","group":"1"}] | 2024-05-06 23:17:06.625000+0000 | 2ba5b169-2596-4b55-a06d-633cd740e044 |        null | DIAL Code Consumption | 0140405158529433600 | [{"id":"0140495851849891840","index":"1","group":"1"}] |         null |      null |        null

(1 rows)

[amitpriyadarshi]

@ddevadat then try hitting this apis.

curl --location 'https://XXXXXXX//api/data/v1/page/create' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer XXXXX' \
--header 'x-authenticated-user-token: XXXXXX' \
--data '{    "request": {
        "name": "DIAL Code Consumption",
        "organisationId": "NA",
        "portalMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ],
        "appMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ]
    }
}'

and restart lms service. also get the cassandra query.

[ddevadat]

on invoking the below request

curl --location 'https://XXXXXXXX//api/data/v1/page/create' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer XXXX' \
--header 'x-authenticated-user-token: XXXX' \
--data '{    "request": {
        "name": "DIAL Code Consumption",
        "organisationId": "NA",
        "portalMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ],
        "appMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ]
    }
}'

I am gettting the below error

{
    "id": "api.page.create",
    "ver": "v1",
    "ts": "2024-05-14 23:16:47:835+0000",
    "params": {
        "resmsgid": null,
        "msgid": "291eea06-9c86-4c5a-9a81-a74a70dd0e1e",
        "err": "INVALID_ORG_ID",
        "status": "INVALID_ORG_ID",
        "errmsg": "INVALID_ORG_ID"
    },
    "responseCode": "CLIENT_ERROR",
    "result": {}
}

[amitpriyadarshi]

@ddevadat can we connect and discuss this in a call?

[ddevadat]

{"timestamp":"2024-05-17T06:58:53.290Z","msg":"Fetching data from Cache for NA:DIAL Code Consumption","lname":"defaultLogger","tname":"application-akka.actor.default-dispatcher-3","level":"INFO","HOSTNAME":"lms-7747594d77-nmt5c","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2024-05-17 06:58:53,290 Fetching data from Cache for NA:DIAL Code Consumption
{"timestamp":"2024-05-17T06:58:53.290Z","msg":"PageManagementActor:getPageData: Exception occurred with error message = No content to map due to end-of-input\n at [Source: (String)\"\"; line: 1, column: 0]","lname":"defaultLogger","tname":"application-akka.actor.default-dispatcher-3","level":"ERROR","stack_trace":"<#0b2a43d6> com.fasterxml.jackson.databind.exc.MismatchedInputException: No content to map due to end-of-input\n at [Source: (String)\"\"; line: 1, column: 0]\n\tat com.fasterxml.jackson.databind.exc.MismatchedInputException.from(MismatchedInputException.java:59)\n\tat com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:4344)\n\tat com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4189)\n\tat com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3205)\n\tat com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3188)\n\tat org.sunbird.learner.actors.PageManagementActor.getDIALPageData(PageManagementActor.java:865)\n\tat org.sunbird.learner.actors.PageManagementActor.onReceive(PageManagementActor.java:87)\n\tat org.sunbird.actor.base.BaseActor.onReceive(BaseActor.java:23)\n\tat akka.actor.UntypedAbstractActor$$anonfun$receive$1.applyOrElse(AbstractActor.scala:337)\n\tat akka.actor.Actor$class.aroundReceive(Actor.scala:539)\n\tat akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:226)\n\tat akka.actor.ActorCell.receiveMessage(ActorCell.scala:610)\n\tat akka.actor.ActorCell.invoke(ActorCell.scala:579)\n\tat akka.dispatch.Mailbox.processMailbox(Mailbox.scala:268)\n\tat akka.dispatch.Mailbox.run(Mailbox.scala:229)\n\tat akka.dispatch.Mailbox.exec(Mailbox.scala:241)\n\tat akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)\n\tat akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)\n\tat akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)\n\tat akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)\n","HOSTNAME":"lms-7747594d77-nmt5c","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2024-05-17 06:58:53,290 PageManagementActor:getPageData: Exception occurred with error message = No content to map due to end-of-input
 at [Source: (String)""; line: 1, column: 0]
com.fasterxml.jackson.databind.exc.MismatchedInputException: No content to map due to end-of-input
 at [Source: (String)""; line: 1, column: 0]
	at com.fasterxml.jackson.databind.exc.MismatchedInputException.from(MismatchedInputException.java:59)
	at com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:4344)
	at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4189)
	at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3205)
	at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3188)
	at org.sunbird.learner.actors.PageManagementActor.getDIALPageData(PageManagementActor.java:865)
	at org.sunbird.learner.actors.PageManagementActor.onReceive(PageManagementActor.java:87)
	at org.sunbird.actor.base.BaseActor.onReceive(BaseActor.java:23)
	at akka.actor.UntypedAbstractActor$$anonfun$receive$1.applyOrElse(AbstractActor.scala:337)
	at akka.actor.Actor$class.aroundReceive(Actor.scala:539)
	at akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:226)
	at akka.actor.ActorCell.receiveMessage(ActorCell.scala:610)
	at akka.actor.ActorCell.invoke(ActorCell.scala:579)
	at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:268)
	at akka.dispatch.Mailbox.run(Mailbox.scala:229)
	at akka.dispatch.Mailbox.exec(Mailbox.scala:241)
	at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
	at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
	at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
	at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

[ddevadat]

Created the page without org id field

curl --location 'https://XXXXXXXX//api/data/v1/page/create' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer XXXX' \
--header 'x-authenticated-user-token: XXXX' \
--data '{    "request": {
        "name": "DIAL Code Consumption",
        "portalMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ],
        "appMap": [
            {
                "id": "0140495851849891840",
                "index": "1",
                "group": "1"
            }
        ]
    }
}'

restarted lms pod.

The db will have entry with orgid "NA"

cqlsh:sunbird> select * from page_management where name='DIAL Code Consumption' ALLOW FILTERING;

 id                  | appmap                                                 | created_date                    | createdby                            | createddate | name                  | organisationid      | portalmap                                              | updated_date | updatedby | updateddate
---------------------+--------------------------------------------------------+---------------------------------+--------------------------------------+-------------+-----------------------+---------------------+--------------------------------------------------------+--------------+-----------+-------------
 0140568942797209600 | [{"id":"0140495851849891840","index":"1","group":"1"}] | 2024-05-17 06:55:47.771000+0000 | 2ba5b169-2596-4b55-a06d-633cd740e044 |        null | DIAL Code Consumption |                  NA | [{"id":"0140495851849891840","index":"1","group":"1"}] |         null |      null |        null
 0140495892056391681 | [{"id":"0140495851849891840","index":"1","group":"1"}] | 2024-05-06 23:17:06.625000+0000 | 2ba5b169-2596-4b55-a06d-633cd740e044 |        null | DIAL Code Consumption | 0140405158529433600 | [{"id":"0140495851849891840","index":"1","group":"1"}] |         null |      null |        null

now qrcode lookup is working fine

[amitpriyadarshi]

@ddevadat if the solution worked, please mark the thread closed.