Error when trying to retrieve data from network: Sql error: Generic SQL error.CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207

(0) Share

Report

Posted on by KrishR

433

Hello Everyone,

I see the following error when trying to retrieve a specific column.

"Error when trying to retrieve data from network: Sql error: Generic SQL error.CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207"

Never seen this error before and I'm not using any sql connections. I'm using data verse as backend and nothing else. Tried the below code to load a specific record from table

Set(VarRec, LookUp(TableName,ID = "5")) and when I see the global variable I see only unique id of the list and ID of the request. Sometimes I see "?" question mark instead of data.

Can anyone please help? Thank you so much in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

VishalJhaveri 1,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

As a heavily experienced person in Power Apps, I can surely say that, if you close and reopen the app after sometime or remove and readd the connection once, this error might no more be troubling you.

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hey @KrishR

did it work in the past and just started to act up?

Can it maybe be a permission issue?

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
The ID field is a number, but in your code you are trying to use a text value of "5" instead of the number 5.

Set(VarRec, LookUp(TableName,ID = 5))

Was this reply helpful? Yes No
KrishR 433 on at

Like (0)

Report
Copy link

Link copied!

@iAm_ManCat @mmbr1606 @VishalJhaveri ,

Thank you so much for all your help.

Tried closing the app for some hours and did reconnect as suggested.

yes, it is working fine before.

Tried the code with Value(5), Text(5), "5". Record pulled but the fields value was blank. I see only GUID value of the list value and the ID of the list (ID is autonumber)

Set(Varrec, LookUp(TableName,ID=5))

Permissions were fine, its still in development and I'm the only one owner on the app.

Thank you so much again!

Was this reply helpful? Yes No
VishalJhaveri 1,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please mark my answer as solution if it helped you.

Was this reply helpful? Yes No
KrishR 433 on at

Like (0)

Report
Copy link

Link copied!

Hi @VishalJhaveri ,

I tried but that didn't help either. Thank you

Was this reply helpful? Yes No