cancel
Showing results for 
Search instead for 
Did you mean: 

SQL generation parameters file could not be loaded SAP Business Warehouse-WIS 00514

Former Member
0 Kudos

Dear Experts,

I have created universe from BEx. After this i have used this universe to create WebI.

But,when i used to create WebI after selecting universe, while refreshing the Query in Query browser, the pop-up is throughing as 'The database SQL generation parameters file could not be loaded SAP Business Warehouse SAP BAPI WIS 00514 '.

I have changed the measure values in universe as Database delegate and into Sum.

  

But stil coming the same error.

Environment: SAP BusinessObjects Business Intelligence 4.0 SP4 Patch 4

Please, guide me how to overcome the error(WIS 00514).

Thanks&Regards,

Raghu.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Chandra,

I faced similar issue on Sybase IQ.  Can you try re-starting ConnectionServer32 in CMC and check. If for some reason  this server is not running properly, it does give this error.

Regards

Piyush

vijaymuniraj
Active Participant
0 Kudos

HI Raghu,

I resolved this error with webi. If u hadn't resolved this so far please follow the below steps.

Step 1

Once u got this error then click ok and u ll get a report with no data (if i am right).

Then Click on Data in right top of Webi report as shown in image.

Step 2

Right click on any one of query and select change Source.

Step 3

Select the universe (if your data source is universe) and universe list ll be shown in Pop up then choose the same universe what u used already and dont forget to Mark apply changes in all queries then click next and click finish.

Step 4

Then it ll show u the object mapping pop up and click finish. Once you done this a query panel will Open dont forget to click apply changes and close

Step 5

Now refresh the report and save 2 or 3 times.

Thanks

Vijay Muniraj.

vijaymuniraj
Active Participant
0 Kudos

Hi Raghu,

Did u resolve this error?

I am facing the same error. Please let me know if u had resolved it.

Thanks

Vijay Muniraj

former_member184594
Active Contributor
0 Kudos

The reason you are getting this is your Bex query probably has changed in time. You need to Refresh the Universe structure in Universe Design Tool.

Former Member
0 Kudos

Hi Zahid Sir,

Thanks for your quick reply.

I have refreshed the Universe structure, but has came pop-up as 'Nothing to Update'.

Please guide me how to solve the above error.

Thanks&Regards,

Raghu.