Forum Discussion

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago
Solved

Dataset refresh manually, but fails when scheduled

Hi team,  I have a Dataset whose refresh need to be scheduled. Initially when I triggered the refresh it throws up a error with code "-2147467259". I searched and found the error was because of tr...
Need Help
  • M0hamedFazil's avatar
    M0hamedFazil
    1 year ago

    Finally, found the solution.
    I have found the root of the problem and it seems to be the appending of two tables. I have checked with different possibilities and all the way seem to refresh, but not the append one.

    initially, I appended the large table with small one and this throws the error. By appending the sammler table to large table, The problem is fixed. 

    I can now schedule the refresh and the dataset is refreshed at the scheduled time

    Regards 
    Fazil M

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago

Finally, found the solution.
I have found the root of the problem and it seems to be the appending of two tables. I have checked with different possibilities and all the way seem to refresh, but not the append one.

initially, I appended the large table with small one and this throws the error. By appending the sammler table to large table, The problem is fixed. 

I can now schedule the refresh and the dataset is refreshed at the scheduled time

Regards 
Fazil M

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    1 year ago

    I'm glad to read you have found it deeping dive into the desktop transformations.

    Regards