Skip to Content

Error when Importing data into a UDT

Hi all,

I am having an issue importing data into a UDT I have created.

Its give the error:

[SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;359 string is too long: Length of input string(22) is longer than defined(20):'-3

I actually dont have any UDF's with a length of 20.

I tested with just default code and name and still get that error. When I do the run simulation there are no errors, its only when clicking on import do I see these errors.

UDT setup

I am not sure if this error is related to the import file or something else.. cant find much info on it.

SAP 9.3 for HANA PL12

Any help is always appreciated.
Thank you
Jerusha

dtw-udt-error.png (28.5 kB)
udt-setup.png (3.0 kB)
Add a comment
10|10000 characters needed characters exceeded

  • Hi Jerusha Lala,

    Glad to know that the issue has been resolved for you.

    If everything works well, you can apply the same in the Production Database.

    Kind regards,

    ANKIT CHAUHAN

    SAP Business One Support

  • Hi ANKIT CHAUHAN

    That resolved my issue thank you very much. I am still testing the import of the entire file, but at least I am not getting the same error and records are importing.

    I also tested the stored procs and they are working ( in a copy of the live database).


    Thanks very much
    Jerusha

  • Hi Jerusha Lala,

    You should always use the templates generated via DTW.

    Also, could you please help to do a test and share the result with me?

    1. Make sure that you are doing it in the copy of the company database and you have the backup in advance for the company database. This is mandatory.

    2. Update the stored procedures SBO_SP_TransactionNotification and SBO_SP_PostTransactionNotice, and change data type of parameter object_type from nvarchar(20) to nvarchar(30). Verify that these stored procedures run correctly after the change.

    3. Test your DTW issue again.

    Kind regards,

    ANKIT CHAUHAN

    SAP Business One Support

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.