Internal Error (-1) Occured [131-183] during Quick Copy in SAP HANA 9.3

[former_member571711]

Good day everyone.

I am planning to copy all the configured settings in a test database to live environment and hence come across the feature "Quick Copy".

What I have done in the Quick Copy is select "Copy To a File" and "Ignore all errors" as the error handling method in the first step, then Internal Error (-1) Occured [131-183] occur when I press 'OK'.

I have also tried a solution in this link which is regarding b1-local-machine.xml file but that does not work.

I did not modify any content in the store procedure SBO_SP_TransactionNotification as well.

SAP HANA version used:

SAP Business One (HANA version) - 9.30.170 PL07

Does anyone have ideas or any solution to this issue?

Thank you.

Best Regards,

Wesley.

[lucca_mello]

Hi Wesley,

Please kindly check my LinkedIn Article that might help you to detect the issue and best practices of Quick Copy.

https://www.linkedin.com/pulse/support-spotlight-top-5-tips-quick-copy-sap-business-one-lucca-mello/

But before checking my article, I strongly suggest you to fix the UDT's and UDF's errors with SAP Note 1076082 - UDT & UDF Related Issues, this will probably lead you to advance to use the Quick Copy tool.

Kind Regards,

Lucca Mello

[francesca3007]

Hello Wesley,

I have the exact same problem but on SAP SQL 10.0.

How did you solve the problem? Can you help me?

Thanks,

Francesca

[Fatih]

 hi @francesca3007 

(I apologize in advance for my spelling mistakes. I use translate because my English is not good.)

I encountered a similar problem today. Since I could not find a clear solution from what was written, I wanted to share what I found. First of all, the link I used is here;
https://www.sapxiaocui.top/index.php/archives/33/

My problem: When I ran the quick copy, I was getting the error "Internal error(-1) 131-183".
I found my faulty tables using the queries that show errors in user-defined tables and fields from the link I gave above.

Spoiler

DETECTION QUERIES FOR HANA:
1) UDT is defined but does not exist. 

select T0."TableName" from OUTB T0 where not exists (select 1 from sys.tables T1 where T1.schema_name = current_schema and T1.is_system_table = 'FALSE' and T1.table_name = '@' || "TableName");

this query gave me inconsistent tables that were not in Hana Sql but were in Sap Business One user tables.
Since these tables were deleted, I could not delete them from user defined tables. For this, I recreated the relevant tables and deleted them from Sap user tables.
When I tried again, the connection was established successfully and I performed the copy operation.

I hope it helps others.
Good work.