cancel
Showing results for 
Search instead for 
Did you mean: 

Why I'm getting database error in web page if rest apis are used

former_member396826
Discoverer
0 Kudos

Hi
I have tried to change my document name of sap bi document using rest api - "http://<host-address>:<host-port>/biprws/raylight/v1/documents/<id>/properties" by using put call, then it was showed the name was changed in rest api's result and also state was changed from "unused" to "modified".
Then, i had called rest api with put call - "http://<host-address>:<host-port>/biprws/raylight/v1/documents/<id>". After calling this rest api the state was changed from "modified" to "original" which means the changes are updated.
Then i tried to reload the webpage and it was giving database error like below attachement.
screenshot-23.png
And also when I tried to see that in application on my hos, but the name was not cahnged.
sap-name-error.png
Not only for the name property it is happening for all other properties.

Accepted Solutions (0)

Answers (1)

Answers (1)

daniel_paulsen
Active Contributor

Hi Erin,

many of the properties returned by /<docID>/properties cannot be modified. I don't know which ones can and which cannot, but the Name of the report is one of the properties you cannot change with the Raylight API.
I have no idea why you get the database error, as I have not seen that happen as a result of making a rest call. Possibly something else was changed/updated in the report.

To change the Name of an infoObject, you should use the BI Platform REST APIs.

To do this:

GET: /biprws/v1/documents/<docId>

PUT /biprws/v1/documents/<docID>

body: results from the GET with a new value for the name attribute

...
<attr name="name" type="string"> new report name</attr>
...
Dan