on 07-25-2012 8:30 PM
Running SAP B1 v8.82 PL04. RDC into the client server.
I'm getting an issue when importing a report. I get all the way to clicking the "Finish" button and it never loads to the next screen (telling me if the import was successful or not). When I go to the location I specified for the report, it appears there but with a different icon and when I click it shows me an error: "No matching records found 'Queries' (OUQR) (ODBC -2028) [Message 131-183]".
Narrowed down the issue a little:
- Happens for any report I try to import
- Happens for both file types (.rpt / .b1p)
- The wizard works in the other databases on the server
- Same issue when I try on different computers with different log ins
There didn't seem to be any major event that triggered the issue. I was in the middle of importing a few reports, and imported a couple successfully, when all of the sudden the issue occurred.
You can also refer to the video link I've attached below which is a complete walk-through of the issue. Any help on this is greatly appreciated, this is really holding me up. Thanks in advance!
-Andrew
Verifique a SAP Note 1532509.
Solution
Please run the below query and if it returns results please Go to the PEQ page mentioned below or log a support message via SAP Service
Marketplace, and attach the results of the query.
select * from CDPM where ObjectType = 232 and ObjectKey not in (select doccode from rdoc) order by permid
Select * from USR3 where PermId
not in (Select distinct Absid from OUPT union Select distinct cast(PermId as nvarchar(50) )from CDPM)
the solution to this note can be found at:
http://wiki.sdn.sap.com/wiki/display/PEQ/Can%27t+import+CR+template+into+B1
By using
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew,
instead of using the SBO "Report and Layout Manager" import function, you may use the Add-in -->> SAP Business One -->> Save As -->>Function of Crystal Report. this method works fine in my end. you may also consider the filenames of your report that you are trying to import, as what Rahul suggested.
regards,
Fidel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Update:
It all works when I save it as a layout. Issue only exists when imported as a report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew.........
There might be this due to two issues.......
1. If any same name report you have imported earlier and its Temp rpt name remains same into DB. So please save it save or rename and save it under other folder and then try to Import.....
2. If Rpt made under different version and rpt is being imported under different version.
Please check..........
Regards,
Rahul
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.