Topic
5 replies Latest Post - ‏2009-05-04T14:04:34Z by SystemAdmin
SystemAdmin
SystemAdmin
533 Posts
ACCEPTED ANSWER

Pinned topic _qsM_FirstName_MCKNAME" Not found

‏2008-07-23T21:44:37Z |
Hi All,

I am trying to Match frequency the data from standardize result data set.

The basic step i take is create a standardize job and save the table definition , in another job i will load this table definition and use the Match frequency stage to generate Frequency data set.

when I tryied to Reference match these stan and Freq files with another reference data sets ( ref_stan and ref_Freq) I got the error "_qsM_FirstName_MCKNAME" Not found"

I came back to search in the match frequency generated file , I did not find this field. While I could do properly a 3 days back.( I could see this field)

I tried many times designing the same stuff from begining with care. But still no luck.

Can any one know why this error comes up ?
Updated on 2009-05-04T14:04:34Z at 2009-05-04T14:04:34Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    533 Posts
    ACCEPTED ANSWER

    Re: _qsM_FirstName_MCKNAME" Not found

    ‏2008-07-24T13:22:38Z  in response to SystemAdmin
    After testing with other name field , the frequency stage is providing the _qsM_FirstName_MCKNAME , but not for the one which am looking for , Can any one help , how to modify my required field so that the Match Frequency stage will generate the _qsM_FirstName_MCKNAME ?

    Thanks much in advance.
  • SystemAdmin
    SystemAdmin
    533 Posts
    ACCEPTED ANSWER

    Re: _qsM_FirstName_MCKNAME" Not found

    ‏2008-09-05T06:23:24Z  in response to SystemAdmin
    Hi,
    Even I have come across the same problem. The error displays - "Match_Contact_INT,0: Variable _qsC_ADDRESS not found in [A] frequency file".

    If you could get a solution for your problem, do post it.

    Thanks
    • SystemAdmin
      SystemAdmin
      533 Posts
      ACCEPTED ANSWER

      Re: _qsM_FirstName_MCKNAME" Not found

      ‏2008-11-05T22:29:35Z  in response to SystemAdmin
      This is typically a user error. There are three possible reasons for this error. The possible causes and solutions are

      1. The link for the frequency file and the dataset are mixed. Check the link ordering in the match stage (see screen shot below).
      2. It might be using an old snapshot of the match spec that is out of alignment. If you're not using fixpack 1a, remove the match spec, re-provision the match spec, re-add the match spec to the job, recompile the job, then run.
      3. It really isn't there. There was an undocumented feature that prevented the Match Frequency stage from recognizing any changes to incoming columns. You would see that a column is going in, but it would not be in the output. The fix then was to delete the Match Frequency stage from the canvas and then add it back in.
  • SystemAdmin
    SystemAdmin
    533 Posts
    ACCEPTED ANSWER

    Re: _qsM_FirstName_MCKNAME" Not found

    ‏2008-12-11T20:44:14Z  in response to SystemAdmin
    Sory for the late reply probably may be useful for future users, before the Frequency stage I have added a Trasformer stage to handle the nulls , I am sure that is one of the following way , can be with if IsNull() then '' else value the other way if len(stripwhitespace(value)) < 1 then '' else value. I could solve with this way.

    Thanks
    • SystemAdmin
      SystemAdmin
      533 Posts
      ACCEPTED ANSWER

      Re: _qsM_FirstName_MCKNAME" Not found

      ‏2009-05-04T14:04:34Z  in response to SystemAdmin
      Hi Raj,
      I am also getting the same or similar issue in the maptch process. could you please on this. see the below error:
      By the way do you work for McKesson?

      Thanks
      Janardhan

      ##I IIS-DSEE-TUTL-00031 09:38:41(001) <main_program> The open files limit is 2000; raising to 2147483647.
      ##I IIS-DSEE-TOSH-00002 09:38:41(002) <main_program> orchgeneral: loaded
      ##I IIS-DSEE-TOSH-00002 09:38:41(003) <main_program> orchsort: loaded
      ##I IIS-DSEE-TOSH-00002 09:38:42(000) <main_program> orchstats: loaded
      ##I IIS-DSEE-TDOD-00080 09:38:42(006) <MWI_Odbc_Write> Process meta data not available in database
      ##I IIS-DSEE-TFSC-00001 09:38:42(008) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
      ##E IIS-QSEE-MATM-00004 09:38:43(000) <QS_Test_MWI_0,0> Variable _qsC_StateAbbreviation_USAREA not found in [A] frequency file

      ##E IIS-QSEE-POTO-00002 09:38:43(001) <QS_Test_MWI_0,0> Fatal error from object qsmExit, code 4

      ##E IIS-DSEE-TFOR-00089 09:38:43(003) <QS_Test_MWI_0,0> The runLocally() of the operator failed.
      ##I IIS-DSEE-TFOR-00094 09:38:43(004) <QS_Test_MWI_0,0> Output 0 produced 201 records.
      ##E IIS-DSEE-TFPM-00040 09:38:43(005) <QS_Test_MWI_0,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
      ##E IIS-DSEE-TFSC-00011 09:38:49(000) <main_program> Step execution finished with status = FAILED.
      ##I IIS-DSEE-TCOS-00026 09:38:49(001) <main_program> Startup time, 0:06; production run time, 0:01.