Topic
  • 3 replies
  • Latest Post - ‏2013-07-31T01:40:30Z by Edward_chan4
Edward_chan4
Edward_chan4
8 Posts

Pinned topic Errors got

‏2013-07-23T10:16:41Z |

Hi,

I put this

=IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

to the rule of the Composite element.

But I get these


M114 ERROR:

Map: f_cargo_remarks Output: TextRef Composite:FTX2

Output argument of rule does not match output type:

=IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+CAST(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

M108 ERROR:

Map: f_cargo_remarks Output: TextRef Composite:FTX2

Rule references unknown map: CAST.

M105 ERROR:

Map: f_cargo_remarks Output: TextRef Composite:FTX2

Rule references unknown type: BOOKING_NO_ID Column:BKHeader AS CHARACTER.

 

Total errors: 3. Total warnings: 0.

when building it. Any ideas?

  • dtx_user
    dtx_user
    23 Posts

    Re: Errors got

    ‏2013-07-23T11:48:47Z  

    Try this

    =IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id CAST( " + TEXT(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" ) and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id=CAST("+ TEXT(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+") and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

  • Edward_chan4
    Edward_chan4
    8 Posts

    Re: Errors got

    ‏2013-07-24T02:46:54Z  
    • dtx_user
    • ‏2013-07-23T11:48:47Z

    Try this

    =IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id CAST( " + TEXT(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+" ) and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id=CAST("+ TEXT(BOOKING_NO_ID Column:BKHeader AS CHARACTER)+") and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

    Thanks. I tried your codes but there're still problems.
    How to correct these
    M113 ERROR:

    Map: f_cargo_remarks Output: TextFunctCd Element:FTX2

    Argument #1 for function NUMBERTOTEXT is invalid.

    M105 ERROR:

    Map: f_cargo_remarks Output: TextFunctCd Element:FTX2

    Rule references unknown type: BOOKING_NO_ID Column:Row:BKHeader.

     

    Total errors: 2. Total warnings: 0.

    due to this?
    =IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+NUMBERTOTEXT(BOOKING_NO_ID Column:Row:BKHeader)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+NUMBERTOTEXT(BOOKING_NO_ID Column:Row:BKHeader)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

    Many Thanks & Best Regards,
    Edward

    Updated on 2013-07-24T04:16:45Z at 2013-07-24T04:16:45Z by Edward_chan4
  • Edward_chan4
    Edward_chan4
    8 Posts

    Re: Errors got

    ‏2013-07-31T01:40:30Z  

    Thanks. I tried your codes but there're still problems.
    How to correct these
    M113 ERROR:

    Map: f_cargo_remarks Output: TextFunctCd Element:FTX2

    Argument #1 for function NUMBERTOTEXT is invalid.

    M105 ERROR:

    Map: f_cargo_remarks Output: TextFunctCd Element:FTX2

    Rule references unknown type: BOOKING_NO_ID Column:Row:BKHeader.

     

    Total errors: 2. Total warnings: 0.

    due to this?
    =IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+NUMBERTOTEXT(BOOKING_NO_ID Column:Row:BKHeader)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "U", "UN", IF (DBLOOKUP("SELECT DECK_IND FROM cargo_details WHERE bl_no_id="+NUMBERTOTEXT(BOOKING_NO_ID Column:Row:BKHeader)+" and rownum=1","-DBType Oracle %IQSHIP_CONN% %IQSHIP_PASS%") = "O", "OD", ""))

    Many Thanks & Best Regards,
    Edward

    Any help please?