| |

VerySource

 Forgot password?
 Register
Search
View: 656|Reply: 3

Help me! Stung by this bug!

[Copy link]

1

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-1-7 20:20:01
| Show all posts |Read mode
Message
Executed as user: REDMOND\svcd. Cannot insert duplicate key row in object 'dbo.EditeGreat8' with unique index 'EG8_FSiteID_CNum_LI_App'. <SpMain: (null): 2601>. [SQLSTATE 42000] (Error 50000). The step failed.
Reply

Use magic Report

0

Threads

11

Posts

9.00

Credits

Newbie

Rank: 1

Credits
9.00

 China

Post time: 2020-1-8 12:27:01
| Show all posts
Because a unique index is created in the table, the column does not allow duplicate values ​​to be inserted. For the data in the table, keep a duplicate record of the unique index column.
Reply

Use magic Report

1

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 Singapore

 Author| Post time: 2020-1-9 17:27:01
| Show all posts
Thank you, but our data table does not allow changes, and a very fatal problem is: "When I run the spMain stored procedure alone, there is no problem; when I run the job alone, there is no problem; but just let When the job is linked to spMain, an error will be reported. The error message is the above message ", and when the job is running, there is no way to track the status of sql. It is really terrible. Thank you!
Reply

Use magic Report

1

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 Singapore

 Author| Post time: 2020-1-15 23:27:01
| Show all posts
Guys and ladies, can anyone help me? Really choking! !!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list