Skip to Content
author's profile photo Former Member
Former Member

Report and Layout Import Wizard issue

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

http://screencast.com/t/g88C39K78Zgs

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2012 at 09:51 PM

    Update:

    It all works when I save it as a layout. Issue only exists when imported as a report.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Sep 24, 2012 at 01:46 PM

    Hello Andrew,

    The answer below I became from my SAP partner. Hopefully this answers your question, because I had the same problem.

    Tim


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 25, 2012 at 12:39 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 08, 2015 at 05:51 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.