Cannot assign an empty string to a parameter with JDBC type VARCHAR

[Former Member]

Hi,

I am seeing the aforementioned error in the logs. I am guessing its happening whenever I am starting an agent instance in PCo. Can somebody explain whats going on?

Regards,

Chanti.

Heres the complete detail from logs -

Log Record Details

Message: Unable to retreive path for , com.sap.sql.log.OpenSQLException: Failed to set the parameter 1 of the statement >>SELECT ID, PARENTID, FULLPATH, CREATED, CREATEDBY, MODIFIED, MODIFIEDBY, REMOTEPATH, CHECKEDOUTBY FROM XMII_PATHS WHERE FULLPATH = ? <<: Cannot assign an empty string to a parameter with JDBC type >>VARCHAR<<.

Date: 2010-03-12

Time: 11:32:37:435

Category: com.sap.xmii.system.FileManager

Location: com.sap.xmii.system.FileManager

Application: sap.com/xapps_xmiiear

....

[jcgood25 · Accepted solution]

Sounds like a UI browsing bug (when no path is selected from a catalog tree folder browser) - I would suggest logging a support ticket so that it can be addressed.