RAR 5.3 SP12 - SU24 Authorizations text file upload error

[Former Member]

Hello,

I am trying to upload the SU24 authorizations text file into RAR (we are on SP12) and getting the below error. I tried to save the text file in UTF-8 format and even that did not help to get rid of the error. Did anyone encounter this problem? Any help is much appreciated.

Cannot assign a java.lang.String object of length 7 to host variable 2 which has JDBC type VARCHAR(3). 
 
 com.virsa.cc.rulearchitect.bo.ObjectTextBO.insertObjectText(ObjectTextBO.java:84) 
 
 com.virsa.cc.comp.UploadTexts.onActionUploadTextObjs(UploadTexts.java:340) 
 
 com.virsa.cc.comp.wdp.InternalUploadTexts.wdInvokeEventHandler(InternalUploadTexts.java:170) 
 
 com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87) 
 
 com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:67) 
 
 com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doHandleActionEvent(WindowPhaseModel.java:420) 
 
 com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:132) 
 
 com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335) 
 
 com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143) 
 
 com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:333) 
 
 com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:741) 
 
 com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:694) 
 
 com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:253) 
 
 com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149) 
 
 com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62) 
 
 com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:53) 
 
 javax.servlet.http.HttpServlet.service(HttpServlet.java:760) 
 
 javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 
 
 com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401) 
 
 com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266) 
 
 com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386) 
 
 com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364) 
 
 com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039) 
 
 com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265) 
 
 com.sap.engine.services.httpserver.server.Client.handle(Client.java:95) 
 
 com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175) 
 
 com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) 
 
 com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) 
 
 com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) 
 
 java.security.AccessController.doPrivileged(Native Method) 
 
 com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104) 
 
 com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

Regards,

Jay

Edited by: jayaroop gullapalli on Oct 13, 2010 9:14 PM

[Former Member · Accepted solution]

Hi ,

I have faced this problem 3 to 4 times in all my project implementations , the only solution which i found is u201C download EditPlus 3u201D and modify the master text file( Delete the special and unrecognised characters from each line ) and save in UTF-8 format , , I spent more than 3 weeks initially to resolve this issue ,but later i have just finished this task in less than 1 hr

Try out, this could help you

Thanks & Regards

Uma Shankar Tekumudi

SAP GRC Consultant

[Former Member · Accepted solution]

There is only one symbol I've ever consistently had problems with: " § ".

There are usually two transactions with that symbol that cause the problem and removing them from the text file allows me to load my files to RAR.

There is also usually a third occurrence of "§" but in the description. For some reason, this is not a problem; only when the symbol occurs in the transaction name section of the file.

-Dylan

[maryjane_steele2 · Accepted solution]

So waht are the transactions?  I have searched for  " § " and can find no hits.  I have also try saving in UTF-8 format with no luck.