topic Re: Select not working after db-migration in Application Development and Automation Discussions

Select not working after db-migration

Private_Member_19084 — Mon, 09 Sep 2013 10:33:50 GMT

Hi experts,

I've a question.

We made a database migration from Oracle to Sybase ASE.

And now I think, that the coding below is not working anymore.

If I check the tables and entries directly via se16 I get a result - like in the past.

But in the program the statement don't delivers any result.

May it be, that the syntax has to be changed for Sybase ASE????

Thank you

btw: header_guid is filled with a correct guid

select single b~partner_guid
    from crmv_linkpartner as a
    inner join but000 as b
    on a~partner_no eq b~partner_guid
    into lv_bupa_guid
    where a~guid_hi eq header_guid
      and a~partner_fct eq 'SLFN0002'
      and a~mainpartner eq 'X'.

IF sy-subrc EQ 0.

Re: Select not working after db-migration

Former Member — Mon, 09 Sep 2013 10:51:45 GMT

It might be due to type issues or simillar. Do you recieve any errors?

Re: Select not working after db-migration

arindam_m — Mon, 09 Sep 2013 11:08:27 GMT

HI,

I would suggest doing the same SQL on a SYBASE client tool that will show the internal representation of the data. See if the Type of the fields in the where clause have the right internal format and type. Often there can be misinterpretation due to VARCHAR and CHAR representation resulting in SQL failure.

Cheers,

Arindam

Re: Select not working after db-migration

Private_Member_19084 — Mon, 09 Sep 2013 12:02:06 GMT

Hi Arindam,

thank you so much for the tip.

Do you have a guide how I can do this in SAP?

Kind regards

Re: Select not working after db-migration

arindam_m — Mon, 09 Sep 2013 12:56:53 GMT

Hi,

Check the link below:

http://www.sybase.com/detail?id=1087327

Download the trail version SQL Anywhere 12.0.1. Then you can connect to your Sybase DB vis this and check the Syntax of the SQL that you have may check out how the data comes up when you do a SELECT * on the tables but000 and crmv_linkpartner and see the data representations.

That should remove the doubts on the data format and also help to understand in the JOIN condition fields and WHERE clause fields have the right values being compared. I mean sometimes the internal and screen representation of a value are different like say for date externally it could be 10.10.2012 internally it might be 20121010.

Cheers,

Arindam

Re: Select not working after db-migration

Private_Member_19084 — Mon, 09 Sep 2013 13:42:33 GMT

I know what you mean, and thx for help.

But we have now tested the following coding below and this works.

So I don't think that it is an conversion issue and so on.
But I've also opened an request at SAP and hope to get an answer.

    SELECT SINGLE *
          FROM crmv_linkpartner
              INTO ls_link
                  WHERE guid_hi EQ header_guid
                    AND partner_fct EQ 'SLFN0002'
                    AND mainpartner EQ 'X'.

    SELECT SINGLE *
              FROM but000
                  INTO ls_but000
                      WHERE partner_guid EQ ls_link-partner_no.

lv_bupa_guid = ls_but000-partner_guid.

Re: Select not working after db-migration

Abhishek_TCS — Thu, 06 Mar 2014 16:26:43 GMT

Dear Christian,

I have the same problem adter migration from ORACLE to DB6, and raised to SAP. But surprisingly they would not release any Note or Correction for this problem. so i am muself looking for options..

Was your problem solved ? Is there any other workaround ??

Regards,

Abhishek

Re: Select not working after db-migration

ThangaPrakash — Thu, 06 Mar 2014 18:23:29 GMT

Hello,

We too had the same problem, we migrated from ORACLE to DB6 and in the beginning the system gave lot of ST22 dumps with TIME_OUT and the execution point shows the SELECT INNER JOINS statements. Our BASIS team has done some maintenance and it solved our issue.

Regards,

Thanga

Re: Select not working after db-migration

Private_Member_19084 — Mon, 10 Mar 2014 06:47:19 GMT

Hello Everyone,

we did maintain the sql-select (removed inner join) and after this change it did work.

Kind regards