Database error: (CS) "Unexpected behavior" . (IES 10901) (Error: INF )

[Former Member]

Hi ,

How can I found more about the error I suddenly got , once I reached a certain limit of rows retrieved from the database (SQL Server 2008)? Filtering some of them helps to avoid the error, but we need all the rows ...
Many thanks,

Augustin

[Former Member · Accepted solution]

Hi,

Looks like there was a conversion error, however the message generated by BO ( Database error: (CS) "Unexpected behavior" . (IES 10901) (Error: INF )   )  is not very explicit .We had a datatype changed from integer to varchar (x) which was not reflected in the universe. After the structure got refreshed everything got back to normal  .

Regards,

Augustin

[Sriram2009]

Hi Augustin

You can find the DB log using the transaction code ST04 and MS Sql log folder. Refer the Microsoft link. https://technet.microsoft.com/en-us/library/ms187885%28v=sql.105%29.aspx

Regards

SS

[Former Member]

Hi Sriram,

Thanks for answering, however there is no DB error logged and the profile does not find anything.The SQL qry of the report runs ok in a querry window.

I will try to see the logs on the server .

Regards,

Augustin

[Sriram2009]

Hi Augustin.

From SAP you can use the transaction code ST04 in the you can find the DB log

Regards

SS