The SQL database has issued an error. please help for this if anybody know

(0) Share

Report

Posted on by account payable

670

Cannot select a record in Category (EcoResCategory).
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'DETAILDESCR'.

1638.error.PNG

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Ajit 8,755 on at

Like (0)

Report

Issue with column DetailedESCR. Can you check the EcoResCategory table is AOT and see if you can find that column. Try to sync that particular table only.

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

when i synchronizing showing like below screenshot .please help

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

Just to confirm, Is it your Prod instance?

I don't see that column in AOT table. Would you please check in SQL and see if that column exist there?

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Yes it is production instance

let me check in sql then i will be back here

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

yes detail description existing in sql ,please find below screenshot file

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

That's the issue. Did someone created that column in SQL directly? You would need to check if that column is required or not. We should always create column from application only. If you don't need that column then you can go ahead and continue in your sync window.

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

no one try to create in sql directly ...Still showing that warning message while i synchronizing

Was this reply helpful? Yes No
Verified answer

account payable 670 on at

Like (0)

Report

Thank you Ajith Srivastava

Now its okey

Was this reply helpful? Yes No
Ajit 8,755 on at

Like (0)

Report

Great. Would you please mark the answers verified.

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Do you know how to hide data using record level security for system admin

i want to hide item in red mark color from the respective column .if you know please help

Was this reply helpful? Yes No