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

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

Hi. That's strange. Try setting other timelines for the refresh. The error sounds like the mysql has some troubles for responding the data. Usually a mashup error means there might be an issue with a value of the data that you have to find it with Desktop. However this time shows that mysql might have a problem, and if it works in another time, it can be an issue of the server or db at that specific time. It could be overloaded.

I hope that helps,

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

    Hi ibarrau 

    Thanks for the reply

    I'm sure that there is no issues with the connectivity of data source.

    Checked with all the transformation and the problem still persists.


    Regards 
    Fazil M