OCI: unable to create book or collection #718

ddevadat · 2024-04-30T03:42:38Z

ddevadat
Apr 30, 2024

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}

Answered by ddevadat

May 17, 2024

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"

cql…

View full answer

vinukumar-vs · 2024-04-30T05:37:30Z

vinukumar-vs
Apr 30, 2024

@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

22 replies

gandham-santhosh May 3, 2024

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

ddevadat May 3, 2024
Author

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 May 3, 2024

@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 May 6, 2024
Collaborator

@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 May 6, 2024
Author

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 · 2024-05-03T22:05:12Z

ddevadat
May 3, 2024
Author

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?

0 replies

ddevadat · 2024-05-06T01:56:10Z

ddevadat
May 6, 2024
Author

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

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.
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": {}
}

2 replies

vinukumar-vs May 6, 2024

@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 May 6, 2024
Author

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 · 2024-05-06T10:28:53Z

amitpriyadarshi
May 6, 2024

@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

1 reply

ddevadat May 6, 2024
Author

Is there any sample payload available example available?

amitpriyadarshi · 2024-05-06T12:22:02Z

amitpriyadarshi
May 6, 2024

@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

7 replies

ddevadat May 7, 2024
Author

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 May 7, 2024
Author

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

amitpriyadarshi May 7, 2024

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

amitpriyadarshi May 7, 2024

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

ddevadat May 7, 2024
Author

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 · 2024-05-08T06:51:36Z

amitpriyadarshi
May 8, 2024

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

5 replies

ddevadat May 8, 2024
Author

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 May 8, 2024

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

ddevadat May 8, 2024
Author

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 May 8, 2024

@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 May 8, 2024
Author

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 · 2024-05-08T09:45:03Z

amitpriyadarshi
May 8, 2024

@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.

1 reply

ddevadat May 14, 2024
Author

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 · 2024-05-15T11:35:22Z

amitpriyadarshi
May 15, 2024

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

0 replies

ddevadat · 2024-05-17T07:01:54Z

ddevadat
May 17, 2024
Author

{"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)

1 reply

ddevadat May 17, 2024
Author

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

Answer selected by ddevadat

amitpriyadarshi · 2024-05-20T06:54:21Z

amitpriyadarshi
May 20, 2024

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

0 replies

OCI: unable to create book or collection #718

Replies: 10 comments · 39 replies

ddevadat May 3, 2024 Author

ashokreddy1208 May 6, 2024 Collaborator

ddevadat May 6, 2024 Author

ddevadat May 3, 2024 Author

ddevadat May 6, 2024 Author

ddevadat May 6, 2024 Author

ddevadat May 6, 2024 Author

ddevadat May 7, 2024 Author

ddevadat May 7, 2024 Author

ddevadat May 7, 2024 Author

ddevadat May 8, 2024 Author

ddevadat May 8, 2024 Author

ddevadat May 8, 2024 Author

ddevadat May 14, 2024 Author

ddevadat May 17, 2024 Author

ddevadat May 17, 2024 Author

Replies: 10 comments 39 replies

ddevadat May 3, 2024
Author

ashokreddy1208 May 6, 2024
Collaborator

ddevadat May 6, 2024
Author

ddevadat
May 3, 2024
Author

ddevadat
May 6, 2024
Author

ddevadat May 6, 2024
Author

ddevadat May 6, 2024
Author

ddevadat May 7, 2024
Author

ddevadat May 7, 2024
Author

ddevadat May 7, 2024
Author

ddevadat May 8, 2024
Author

ddevadat May 8, 2024
Author

ddevadat May 8, 2024
Author

ddevadat May 14, 2024
Author

ddevadat
May 17, 2024
Author

ddevadat May 17, 2024
Author