Cfhttp column problem

Report · Oct 20, 2009

Hi

I'm working with a ColdFusion Server MX Version 7.0.2.x.

On the old server we have an import-job which imports a txt file into the Oracle table. For this we use the cfhttp function which works well on the old server.

Now we have installed the same application on a new, identical CF server. On the new server we have the problem that we get this error-message for the same import-job:

The column name "" is invalid.
Column names must be valid variable names. They must start with a letter and can only include letters, numbers, and underscores.

This is the cfhttp tag that we are using:

<cfhttp method="get" url="#StartURL#COKEHDML_it_dash.txt" name="Milestone" delimiter=";" charset="windows-1252"></cfhttp>

A sample of the imported text file is attached.

Extrakt_Dttm;PSP_2;Netzplannummer;Vorgangsnummer;Mlst_No;Beschreibung;Verwd;Term iniert;Fixtermin;Isttermin;Eckstart_X1;Fixstart_X1
2009-09-08 19:43:43;X-000071-2;X000071-2N;C001;000000028371;Meldungsbereinigung abgeschlossen;;30.06.2002;30.06.2002;;30.06.2002;30.06.2002
2009-09-08 19:43:43;X-000071-2;X000071-2N;C001;000000028372;Realisierung abgeschlossen;;31.12.2002;;;06.03.2003;
2009-09-08 19:43:43;X-000071-2;X000071-2N;C001;000000028373;Bereitstellung GIKUS-Zentralen;;31.10.2002;31.10.2002;;31.10.2002;31.10.2002
2009-09-08 19:43:43;X-000071-2;X000071-2N;C001;000000028374;Logenoptimierung abgeschlossen;;30.09.2002;30.09.2002;;30.09.2002;30.09.2002
2009-09-08 19:43:43;X-000071-2;X000071-2N;C001;000000028375;Organisationsspezifikation erstellt;;30.09.2002;30.09.2002;;30.09.2002;30.09.2002
2009-09-08 19:43:43;X-000071-2;X000071-2N;D001;000000028376;Einführung abgeschlossen;;31.12.2002;;;06.03.2003;
2009-09-08 19:43:43;X-000535-4;X000535-4N;C001;000000079457;Production Sign Off;A020;31.12.2009;31.12.2009;;31.12.2009;31.12.2009

What is the problem, and can it be fixed with settings on the application server?

Thanks for the help!

René

Report · Oct 20, 2009

Are you sure you are not GETting a file with a double semicolon ;; in the first row?

Report · Oct 20, 2009

Hi Alex

Yes i'm sure, that i'm not geting a false file.

You see the first row original.

Thanks René

Report · Oct 25, 2009

To debug, add the attribute firstRowAsHeaders= "no". This will force Coldfusion to generate its own columns, column_1, column_2, and so on. You should then examine the second row to see whether the names Extrakt_Dttm, PSP_2, etc., fall under the respective columns.