Symptom:
unable to connect: incorrect log on parameters. Details: [Database Vendor Code: xxxxx]
Troubleshooting Steps:
Please find the below steps for troubleshooting on LOV Issues:
5. Note down the name of LOV from the option: Existing (under Choose a Data Source)
6. Login to Business View Manager (BVM). (Use an Administrator account and Enterprise Authentication)
7. It would open Welcome wizard. (Click on Cancel button)
8. You can see Repository Explorer on right side. (If not, Click on View > RepositoryExplorer)
9. Locate the LOV name as seen in Crystal Reports and Click on the LOV. (E.g. Customer Name)
Now we have found the problematic List of Value (LOV).
Start troubleshooting for this LOV:
3. It will show you the referenced objects:
Here, you can see the Data Connection (DC), Data Foundation (DF), Business Element (BE) and Business View (BV) related to the selected LOV.
4. Open Data Connection and test it. If the test is successful then perform the below steps. If you receive any error message then edit the connection and do the required changes.
5. Open Data Foundation. Right click on one of the database objects and select Browse Field from Object Explorer. If you get data for the browsed field then perform below steps.
6. Open Business Element. Right click on one of the database objects and select Browse Field from Object Explorer. Check if you get data for the browsed field.
Note: At this point, if everything works fine, create a new Crystal report based on same Business View. (Follow steps 12 to 15). If you do not get data in Step 15 then perform the below steps:
7. Right click on Data Connection and select Edit Rights from Repository Explorer.
8. Edit Rights window would open. Now check Rights for Data Access by clicking on Preview:
9. You can explicitly set Granted Rights to the User or Administrator.
10. Right click on LOV and select Schedule List of Values from Repository Explorer.
11. Check the Schedule status by double clicking on the same LOV.
If the schedule status is failed then perform the below steps:
12. Launch Crystal Reports designer.
13. Create a new report on the same Business View on which the LOV is based on.
14. Insert the field (on which the LOV is based on) in the Detail section of the report.
15. If you get data in Crystal Reports then it proves that BVM Data Connection is fine.
16. Save the report to the Enterprise and schedule it.
17. If schedule fails, you need to do troubleshooting on BI servers.
Troubleshooting on BI Servers
If the scheduled List of values are failing in Business View Manager, you need to do troubleshooting on BI server machine.
Information:
Note: When you explicitly edit the values (or select the values dynamically) from Report Properties > Schedule > Prompts > Edit Values, at that time along with above servers, CRPS and Crystal Report Cache Server come into the picture.). Find below screenshot.
LOV OnDemand: When there is no LOV scheduled in BVM (Clear the intance in BVM by editing the LOV), when you refresh
the report in CMC which has that LOV, Crystal Reports Processing Server (CRPS) and Crystal Reports Cache server come into the picture.
Scheduled LOV: When we explicitly schedule an LOV in BVM (Like Hourly, Weekly, Monthly...) Adaptive Job server (In 4.0/4.1) / LOV Job server (In 3.1), Input File Repository (IFRS) and Output File Repository (OFRS) come into picture.
Troubleshooting Steps:
c. - You can verify PATH in Environment Variables.
d. - In case of SQL Server, create a 32bit DSN and test the connection. (Launch odbcad32.exe from the location: C:\Windows\SysWOW64\odbcad32.exe)
3. Check the Network security and firewall configuration.
1813053 - Empty Dynamic LOV box in Crystal Reports Designer
Unable to get updated List of Values:
Troubleshooting for migrated LOV’s
References:
Crystal Reports (BI-RA-CR):
BI Servers (BI-BIP-ADM):
Deployment (BI-BIP-DEP):
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 |