cancel
Showing results for 
Search instead for 
Did you mean: 

The job is terminated due to the error <70401>

Former Member
0 Kudos

Am getting the running this job Job_DM_Lookups_SAPToApp.My data services is 4.2 sp9 windows server 2012 r2 mssql 2012 connection to hana platform 1.0.

find below the error log file

(14.2) 07-31-17 16:20:35 (W) (8984:0400) VAL-030299: |SESSION Job_DM_Lookups_SAPToApp Warning: The data returned by the <replace_substr> function could be truncated because return size is reduced from <170750> to <8192>. If data truncation occurs, adjust the Replace_Substr_Max_Return_Size_Characters parameter in the DSConfig.txt file. (14.2) 07-31-17 16:28:20 (R) (8984:0400) DBS-070401: ODBC data source <QCGLIMITEDBI\SQLEXPRESS> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.>. (14.2) 07-31-17 16:28:20 (E) (8984:0400) DBS-070401: ODBC data source <QCGLIMITEDBI\SQLEXPRESS> error message for operation <SQLExecute>: <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. (14.2) 07-31-17 16:28:20 (R) (8984:0400) DBS-070401: |Session Job_DM_Lookups_SAPToApp ODBC data source <QCGLIMITEDBI\SQLEXPRESS> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.>. (14.2) 07-31-17 16:28:20 (E) (8984:0400) DBS-070401: |Session Job_DM_Lookups_SAPToApp ODBC data source <QCGLIMITEDBI\SQLEXPRESS> error message for operation <SQLExecute>: <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. (14.2) 07-31-17 16:28:20 (R) (8984:0400) RUN-050304: |Session Job_DM_Lookups_SAPToApp Function call <sql ( DS_STG_MGMT_LKP, INSERT INTO DBO.LKP_BUS_TRANSACT_TYPE SELECT KEY_LEGACY,K01,K02,K03,K04,'2017.07.31 16:20:36' FROM DBO.LOOKUP_DATA_UPDATE_SAPTOAPP WHERE LKP_TABLE = 'LKP_BUS_TRANSACT_TYPE' And DI_TIMESTAMP = '2017.07.31 16.20.36' ) > failed, due to error <70401>: <ODBC data source <QCGLIMITEDBI\SQLEXPRESS> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.>.>. (14.2) 07-31-17 16:28:20 (E) (8984:0400) RUN-050304: |Session Job_DM_Lookups_SAPToApp Function call <*****> failed, due to error <*****>: <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. (14.2) 07-31-17 16:28:23 (E) (8984:0400) RUN-050316: |Session Job_DM_Lookups_SAPToApp The job <Job_DM_Lookups_SAPToApp> is terminated due to the error <70401> (14.2) 07-31-17 16:28:23 (R) (8984:0400) RUN-050304: |Session Job_DM_Lookups_SAPToApp Function call <raise_exception ( The job <Job_DM_Lookups_SAPToApp> is terminated due to the error <70401> ) > failed, due to error <50316>: <The job <Job_DM_Lookups_SAPToApp> is terminated due to the error <70401>>. (14.2) 07-31-17 16:28:23 (E) (8984:0400) RUN-050304: |Session Job_DM_Lookups_SAPToApp Function call <*****> failed, due to error <*****>: <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. (14.2) 07-31-17 16:28:23 (R) (8984:0400) RUN-050316: |Session Job_DM_Lookups_SAPToApp The job <Job_DM_Lookups_SAPToApp> is terminated due to the error <70401> (14.2) 07-31-17 16:28:23 (E) (8984:0400) RUN-050316: |Session Job_DM_Lookups_SAPToApp ODBC data source <QCGLIMITEDBI\SQLEXPRESS> error message for operation <SQLExecute>: <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. strator to assign additional privileges to your account. (14.2) 07-31-17 16:28:23 (E) (8984:0400) RUN-050316: |Session Job_DM_Lookups_SAPToApp The job <Job_DM_Lookups_SAPToApp> is terminated due to the

Accepted Solutions (1)

Accepted Solutions (1)

former_member198401
Active Contributor
0 Kudos

This exception occurs when your datatype,size does not match with database field attributes. kindly check the datatype of columns of input schema which donot match the target schema column datatypes

Former Member
0 Kudos

Thanks alot i had to review the datatypes and sizes for both source and target and made all of them the same datatype and size

former_member198401
Active Contributor
0 Kudos

Perfect!! Glad to hear that the issue is resolved 🙂

0 Kudos

Hi, I am having a similar issue. How do you view and compare the data types?

Where do I view this in Data Services Designer?

Thanks

former_member598107
Participant
0 Kudos
bmorestance

What is the DS Designer and Job server version on which you are getting this error. Is this a Windows and UNIX box.

Could you please let me know if you are receiving the same error. <SQLExecute>: <[Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.>

Please check SAP note 1832800 - Error DBS-070401 when executing batch job. This SAP Note mentions about the Code page. Please check the codepage of database and set it accordingly in DS Designer under the datastore configuration.

You can check the option under Debug>View design time data option to see how data looks before and after transformation.

https://blogs.sap.com/2013/01/10/view-design-time-data-in-ds-41/

Hope this helps!!

Regards

Arun Sasi

Answers (1)

Answers (1)

former_member198401
Active Contributor
0 Kudos

Looks like you are inserting a date with a timestamp in the target table. This can also be the root cause of the error. Check what is the data type of the column in DBO.LKP_BUS_TRANSACT_TYPE. If it is date then try to change it as datetime to include the timestamp

Refer below MSDN post

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ec184168-ddd1-4df5-b2c7-c6671b602a3d/string...

Regards

Arun Sasi

Former Member
0 Kudos

I changed the data type for DBO.LKP_BUS_TRANSACT_TYPE from datetime to nvarchar and date it didnt work still getting the same error