Topic
13 replies Latest Post - ‏2013-01-22T20:25:59Z by HariPrashath
HariPrashath
HariPrashath
28 Posts
ACCEPTED ANSWER

Pinned topic Prob in Moving a Package from Dev to Prod

‏2013-01-16T13:24:34Z |
Hi All,

I Have a problem in Migration of Package from Dev to Prod.

• I have used the import/export option to move a package from Dev to Prod.
• The Dev Database name is "EDWD" and Prod database is "EDWP"
• The Datasource is EDW which is available in both Dev and Prod both pointing to its respective databases.

When I try running the report in Prod the following error message is displayed.
In the error message I was able to makeout that the still it is pointing to the Dev Database "EDWD".
I have re-checked the Datasource connection string it is pointing to Prod db only.

Error Msg:
An error occurred while performing operation 'sqlPrepareWithOptions' status='-56'.
UDA-SQL-0115 Inappropriate SQL request.UDA-SQL-0564 Microsoft OLE DB Provider for SQL ServerDeferred prepare could not be completed.UDA-SQL-0564 Microsoft OLE DB Provider for SQL ServerStatement(s) could not be prepared. (SQLSTATE=42000, SQLERRORCODE=8180)UDA-SQL-0564 Microsoft OLE DB Provider for SQL ServerInvalid object name 'EDWD.dbo.LU_Branch_Region'. (SQLSTATE=42S02, SQLERRORCODE=208)RSV-SRV-0042 Trace back:RSReportService.cpp(826): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(789): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(250): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(842): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand():
Kindly suggest some ideas

Thanks

HP
Updated on 2013-01-22T20:25:59Z at 2013-01-22T20:25:59Z by HariPrashath
  • J.BJERRE
    J.BJERRE
    52 Posts
    ACCEPTED ANSWER

    Re: Prob in Moving a Package from Dev to Prod

    ‏2013-01-16T13:56:54Z  in response to HariPrashath
    Hi HP

    Have you checked that the LU_Branch_Region object is existing in the Prod DB?

    Regards
    J.Bjerre
    • HariPrashath
      HariPrashath
      28 Posts
      ACCEPTED ANSWER

      Re: Prob in Moving a Package from Dev to Prod

      ‏2013-01-16T14:01:45Z  in response to J.BJERRE
      Hi,

      Yes the table is available, all the tables in Dev are in Prod.

      Moreover in the error you can see the EDWD.dbo.LU_Branch so its is still pointing to Dev database.
      The reason why it give a error message the Datasource is pointing to Prod Server but for some reason Dev Database name "EDWD" gets generated in SQL.

      Thanks

      HP
  • DanielWagemann
    DanielWagemann
    411 Posts
    ACCEPTED ANSWER

    Re: Prob in Moving a Package from Dev to Prod

    ‏2013-01-16T14:34:29Z  in response to HariPrashath
    You probably have different FM models for Dev and Prod. I am assuming it is picking up the data source name from what is defined in these models prior to being published.

    You should be able to correct this in the model and do a re-publish.

    To do this properly, you should have the same data source name in both environments. Under that data source you can define the the connection to point to a different server/database without affecting the package.
    • neni
      neni
      42 Posts
      ACCEPTED ANSWER

      Re: Prob in Moving a Package from Dev to Prod

      ‏2013-01-16T14:43:37Z  in response to DanielWagemann
      while doing the export of the package did you selected the data sources option also ?
      • HariPrashath
        HariPrashath
        28 Posts
        ACCEPTED ANSWER

        Re: Prob in Moving a Package from Dev to Prod

        ‏2013-01-16T14:48:46Z  in response to neni
        No I have not exported the datasource.
        • HariPrashath
          HariPrashath
          28 Posts
          ACCEPTED ANSWER

          Re: Prob in Moving a Package from Dev to Prod

          ‏2013-01-17T09:24:35Z  in response to HariPrashath
          Hi,

          Even this is not resolving this issue.

          Anymore suggestions

          Thanks

          HP
          • neni
            neni
            42 Posts
            ACCEPTED ANSWER

            Re: Prob in Moving a Package from Dev to Prod

            ‏2013-01-17T15:16:49Z  in response to HariPrashath
            Please check confirm the following.
            1) If you create a new report using the package will that report execute without any error ?
            2) If you create a new report using the package just adding text item and nothing form the metadata will that report run?
            3) Is the data source name in COGNOS is same in both the environments(Dev &Prod) and the data source name in FM?
            • HariPrashath
              HariPrashath
              28 Posts
              ACCEPTED ANSWER

              Re: Prob in Moving a Package from Dev to Prod

              ‏2013-01-21T16:36:22Z  in response to neni
              Neli,

              Thanks for the Reponse. I have placed all the steps in the attached document,please refer to that and Kindly suggest me a approach.

              Thanks

              HP
              • HariPrashath
                HariPrashath
                28 Posts
                ACCEPTED ANSWER

                Re: Prob in Moving a Package from Dev to Prod

                ‏2013-01-22T06:01:18Z  in response to HariPrashath
                Hi,

                Any Luck on this issue.

                Thanks

                HP
              • HariPrashath
                HariPrashath
                28 Posts
                ACCEPTED ANSWER

                Re: Prob in Moving a Package from Dev to Prod

                ‏2013-01-22T06:01:19Z  in response to HariPrashath
                Hi,

                Any Luck on this issue?

                Thanks

                HP
                • DanielWagemann
                  DanielWagemann
                  411 Posts
                  ACCEPTED ANSWER

                  Re: Prob in Moving a Package from Dev to Prod

                  ‏2013-01-22T14:30:33Z  in response to HariPrashath
                  The answer to your problem is within the screen captures of your previsouly attached word document.

                  You have specified a catalog entry of EDWD within your model. This is the catalog the package is going to use until you change it and re-publish the model.

                  A deployment will not change this hard coded value for you.

                  As I posted earier, the right way of doing this is to have two identical databases for Dev and Prod with the same name, catalog and schema. From there you can control the access via the connections and their associated permissions.

                  Since you have different catalogs, you will need to figure out a way to make this portable.
                  • neni
                    neni
                    42 Posts
                    ACCEPTED ANSWER

                    Re: Prob in Moving a Package from Dev to Prod

                    ‏2013-01-22T16:12:18Z  in response to DanielWagemann
                    Whatever Daniel has suggested is absolutely correct.
                    Either you create the Database, Schema, Catalog same in both the environments or else try to change the catalog in prod environment to same as DEV. Once you make these changes then you should not have any issue
                    • HariPrashath
                      HariPrashath
                      28 Posts
                      ACCEPTED ANSWER

                      Re: Prob in Moving a Package from Dev to Prod

                      ‏2013-01-22T20:25:59Z  in response to neni
                      Thanks Daniel,Neni. I appreciate your efforts.

                      Thanks a ton

                      HP