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.

[Former Member]

Hi Sunny

I have already gone through the related threads, and saving in UTF-8 format did not hel either.

Hi Surpreet,

I have 200,000+ lines and I have no clue how i would find those specials chars.

[Former Member]

jaya,

yes i understand your concern, however you have to go through that painful process of mannually checking the file.

i use to open customer files in MS word and click technical view on (which will show you tab's and enter's) in the word.

then i use to check every page for extra tab or enter or special char at any line.

in your case since file are downloaded using programs in SA38, so no chance of extra tab or enter

only option left is special char, either use advance find option or just down list of all users, may be someone have name with special char.

sorry no other way......

regards,

Surpreet

check for char like special u in below name

Katrin Rühle

Edited by: Surpreet Singh Bal on Oct 15, 2010 9:58 AM

[Former Member]

Yes any special character in the file can cause issue.

[sunny_pahuja2]

Hi,

Check below thread:

Thanks

Sunny