Error encountered when configuring Object Selector

[Former Member]

I'm trying to complete the <a href="http://help.sap.com/saphelp_nw04s/helpdata/en/43/8d77556536267fe10000000a1553f7/content.htm">"My First Composite Application"</a> tutorial and am encountering an internal server error. The error occurs on step 8 of "Configuring the Object Editor User Interface". The error displayed in the Browser is:

The initial exception that caused the request to fail, was:

com.sap.sql.log.OpenSQLException: Cannot assign a java.lang.String object of length 9 to host variable 7 which has JDBC type VARCHAR(4).

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)

at com.sap.sql.types.GenericResultColumn.checkLength(GenericResultColumn.java:212)

at com.sap.sql.types.VarcharResultColumn.setString(VarcharResultColumn.java:63)

at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:505)

... 66 more

Any insight on what might be causing this error is greatly appreciated.

Regards,

Brian Vandehey

Message was edited by: Brian Vandehey

[Former Member · Accepted solution]

Hi Brian,

I thought that the problem occurred when you updated CAF business entity.

But the problem source in the wd runtime repository. Locale of translatable attribute is calculated incorrectly when you are trying to save according configuration. It seems to be a bug.

I don't remember such problem.

I would propose to change your UME user locale to "en" or "de" and try to save configuration again after relogin.

Best regards,

Aliaksei.

[Former Member · Accepted solution]

Aliaksei,

Assigning a language to my User ID solved the problem. Object Editor and Object Selector patterns are now working fine. Thank you for your help with resolving this issue.

Regards,

Brian Vandehey

[Former Member]

Hi Brian,

The problem is that you tried to put 9 length value to 4 length field.

Actually object editor should not allow to put a value which is longer than described in metadata.

Try to detemine a field which have length 4 in your entity and put these details here.

Please provide full stacktrace displayed in the browser.

Also try to complete tutorial. Configure object selector and specify your object editor configuration within as it described. Execute object selector, and try again - possible this problem is possible for preview mode only.

Best regards,

Aliaksei.

[Former Member]

Aliaksei,

Thank you for your help on this. I tried to enter short names (4 characters) for the Configuration Name, Title and any other field where data is required for configuring a an Object Editor WD pattern, but I still am getting the error. I then went back and tested the entity services for Car and Employee using the CAF test tool, and they are working fine. I was able to successfully create, update, query, and delete records for both entity services. The problem looks to me like an issue with the UI Configuration Browser component itself. I've successfully completed all steps in the tutorial with the exception of the last 2 which involve configuring the Object Editor and Object Selector UI components. I'm getting the following error in both cases.

Below is the root cause message along with the full stack trace. Thank you for your help with this.

Regards,

Brian Vandehey

<b>Root Cause</b>

The initial exception that caused the request to fail, was:

com.sap.sql.log.OpenSQLException: Cannot assign a java.lang.String object of length 9 to host variable 7 which has JDBC type VARCHAR(4).

<b>Full Exception Chain</b>com.sap.tc.webdynpro.repository.RepositoryRuntimeException: Failed to set Attribute Value for the object 1447091977.searchCars.xml, attribute startCaption, value SearchforCars.

at com.sap.tc.webdynpro.repository.model.DelegatorRepositoryModelClass.setAttributeValue(DelegatorRepositoryModelClass.java:623)

at com.sap.caf.ui.utils.repository.context.ContextWriter.saveElementAttributes(ContextWriter.java:238)

at com.sap.caf.ui.utils.repository.context.ContextWriter.saveRootNode(ContextWriter.java:109)

at com.sap.caf.ui.utils.repository.context.ContextWriter.saveToRepository(ContextWriter.java:66)

at com.sap.caf.ui.utils.repository.ReposUtils.saveContextNodeBranch(ReposUtils.java:146)

at com.sap.caf.ui.ptn.searchbar.SearchBarCC.saveContext(SearchBarCC.java:504)

at com.sap.caf.ui.ptn.searchbar.wdp.InternalSearchBarCC.saveContext(InternalSearchBarCC.java:318)

at com.sap.caf.ui.ptn.searchbar.config.SearchConfiguratorLayout.onEventSaveConfiguration(SearchConfiguratorLayout.java:622)

at com.sap.caf.ui.ptn.searchbar.config.wdp.InternalSearchConfiguratorLayout.wdInvokeEventHandler(InternalSearchConfiguratorLayout.java:443)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)

at com.sap.tc.webdynpro.progmodel.controller.Component.fireEvent(Component.java:278)

at com.sap.caf.ui.ptn.searchbar.wdp.InternalSearchBarCC.wdFireEventSaveConfiguration(InternalSearchBarCC.java:482)

at com.sap.caf.ui.ptn.searchbar.SearchBarCC$ConfigurationToolbarDataManipulator.saveData(SearchBarCC.java:1669)

at com.sap.caf.ui.ptn.common.components.configtoolbar.api.AbstractConfigurationToolbarDataManipulator$ConfigurationManager.save(AbstractConfigurationToolbarDataManipulator.java:164)

at com.sap.caf.ui.ptn.common.components.configtoolbar.controllers.ConfigurationToolbarCC.save(ConfigurationToolbarCC.java:194)

at com.sap.caf.ui.ptn.common.components.configtoolbar.controllers.wdp.InternalConfigurationToolbarCC.save(InternalConfigurationToolbarCC.java:160)

at com.sap.caf.ui.ptn.common.components.configtoolbar.views.ConfigurationEditorToolbarCV.saveAndMaybeReturn(ConfigurationEditorToolbarCV.java:388)

at com.sap.caf.ui.ptn.common.components.configtoolbar.views.ConfigurationEditorToolbarCV.onActionPreview(ConfigurationEditorToolbarCV.java:309)

at com.sap.caf.ui.ptn.common.components.configtoolbar.views.wdp.InternalConfigurationEditorToolbarCV.wdInvokeEventHandler(InternalConfigurationEditorToolbarCV.java:232)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)

at com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:67)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doHandleActionEvent(WindowPhaseModel.java:422)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:133)

at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:344)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:298)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:705)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:659)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:227)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:150)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:56)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:47)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: com.sap.tc.webdynpro.repository.RepositoryRuntimeException: Cannot assign a java.lang.String object of length 9 to host variable 7 which has JDBC type VARCHAR(4).

at com.sap.tc.webdynpro.serverimpl.wdc.repository.DBStreamVMOLocator.getLanguageResourceInputStream(DBStreamVMOLocator.java:97)

at com.sap.tc.webdynpro.repository.persistence.xml.XMLLanguageResourceParserWriter.parseLanguageResource(XMLLanguageResourceParserWriter.java:146)

at com.sap.tc.webdynpro.repository.persistence.xml.XMLLanguageResourceParserWriter.readLanguageResources(XMLLanguageResourceParserWriter.java:84)

at com.sap.tc.webdynpro.repository.persistence.xml.XMLPersistence.doReadVMOTranslatableTexts(XMLPersistence.java:191)

at com.sap.tc.webdynpro.repository.persistence.RepositoryPersistence.readVMOTranslatableTexts(RepositoryPersistence.java:246)

at com.sap.tc.webdynpro.repository.model.Repository.readVMOTranslatableTexts(Repository.java:1102)

at com.sap.tc.webdynpro.repository.model.TextHandler.getTranslatableText(TextHandler.java:215)

at com.sap.tc.webdynpro.repository.model.AbstractRepositoryModelClass.getValueInVariant(AbstractRepositoryModelClass.java:852)

at com.sap.tc.webdynpro.repository.model.NonSharedRepositoryModelClass.getValue(NonSharedRepositoryModelClass.java:697)

at com.sap.tc.webdynpro.repository.model.NonSharedRepositoryModelClass.setAttributeValue(NonSharedRepositoryModelClass.java:383)

at com.sap.tc.webdynpro.repository.model.DelegatorRepositoryModelClass.setAttributeValue(DelegatorRepositoryModelClass.java:620)

... 47 more

Caused by: com.sap.sql.log.OpenSQLException: Cannot assign a java.lang.String object of length 9 to host variable 7 which has JDBC type VARCHAR(4).

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)

at com.sap.sql.types.GenericResultColumn.checkLength(GenericResultColumn.java:212)

at com.sap.sql.types.VarcharResultColumn.setString(VarcharResultColumn.java:63)

at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:505)

at com.sap.sql.sqlj.runtime.profile.ref.RTStatementJDBCPrepared.setString(RTStatementJDBCPrepared.java:359)

at com.sap.tc.webdynpro.repository.persistence.db.DatabaseStatements.joinLangResourceForVMO(DatabaseStatements.java:1357)

at com.sap.tc.webdynpro.repository.persistence.db.DatabaseHelper.readLanguageResourceByteArray(DatabaseHelper.java:280)

at com.sap.tc.webdynpro.serverimpl.wdc.repository.DBStreamVMOLocator.getLanguageResourceInputStream(DBStreamVMOLocator.java:95)

... 57 more