Analytics Software

Going through a variety of different forums I see that many have encountered this error but I could not find any definitive solution to the same hence the thread.

I created an initialization block with 8 dynamic repository variables and see the following error in the Server log. Since all the variables change values monthly it was only going through the log files that exposed this.

[nQSError: 43059] Init block 'VDW_DT_CTL': Dynamic refresh of repository scope variables has failed.

Things I have tried:

1. I have tested the initialization block with the RPD in "Online Mode" and the query executes fine and populates the expected results. So I am presuming that it is able to connect just fine to the DB.

2. I have also given a fully qualified DSN within the RPD connection pool such that it does not depend on referencing the tnsnames.ora file for the DB connection details. All the reports working off another connection pool with similar details work just fine.

It would be of great help if someone who has effectively solved this could help out with some insight of what I could look at. Again, most of the threads on this topic seem to be left unanswered and hence the enquiry.

Thanks,

Ganesh Moovera