SQL error during data upgrade

(0) Share

Report

Posted on by NavTech

2,382

I am getting below error during data upgrade into 2015 .

A call to System.Data.SqlClient.SqlCommand.ExecuteNonQuery failed with this message: Subquery returned more
than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is
used as an expression.
The statement has been terminated.

Some sql subquery is returning more than value . Is there any way I can trace the value on which this is the error. Is there any way to debug this.

*This post is locked for comments

All responses (3)

Answers (2)

Verified answer

NavTech 2,382 on at

Like (0)

Report

RE: SQL error during data upgrade

I run the profiler and got some wrong data in document dimension table . fixed it .
Suggested answer

Saurav.Dhyani 17,965 Super User 2024 Season 2 on at

Like (0)

Report

RE: SQL error during data upgrade

What is the company name in the database.

After NAV 2013 R2 microsoft suggest to remove all special characters from company name before doing a data migration.
Verified answer

keoma 32,675 on at

Like (0)

Report

RE: SQL error during data upgrade

You could rerun data upgrade and run sql profiler before starting upgrade.