Re: Geonames pipeline failure due to source URL : INC2958573

[Marc Wick]

Hi Nanditha

Your subscription has expired. The html page is telling you this.
Please prolong the subscription to re-enable access.

Best Regards

Marc

Doma, Nanditha wrote:
> HI @Vemula, Anil Kumar <mailto:avem...@amgen.com>/@Home, David
> <mailto:dh...@amgen.com>/@Aynlender, Sandra <mailto:aayn...@amgen.com>,
>
> We have observed that, the geonames pipeline
> (edf_microbatch_ingestion_geonames_prd)  has failed with the below error:
>
> We have done our initial analysis and identified that the data read from
> the URL –
> ‘*http://www.geonames.org/premiumdata/latest/<table_name>.<txt>/<zip>*’
>
> is being returned in HTML format instead of *tab* *format*. As a result,
> the pipeline is unable to process the data correctly, resulting in job
> failure.
>
> Could you please help us investigate further to identify the root cause
> and sorting the issue? (screenshots attached for reference).
>
> /Thanks & Regards,/
>
> /Nanditha Doma.
>
> /
>

[Marc Wick]

Hi Nanditha

It should be fixed. Can you recheck?

Background: we had slow ssl connections on the www server and had moved
to a backup server. Because of an error in the config oct and nov have
not been displayed from the backup server.

Best Regards

Marc

Doma, Nanditha wrote:

> Hi Team,
>
> Geonames pipeline in CDL has been failed with the below error message
> “*The number of columns doesn't match”. * Please find the snapshot for
> more details.

>
> We have done our initial analysis and identified that the data read from
> the URL –
> ‘*http://www.geonames.org/premiumdata/latest/<table_name>.<txt>/<zip>*’
>

> is being returned in *HTML* format instead of *tab* format**due to”*_the
> requested URL was not found on this server_*_“_. As a result, the

> pipeline is unable to process the data correctly, resulting in job failure.
>

> Could you please check on the above issue and assist us further.?_
>
> Thanks and Regards,
>
> Nanditha Doma
>
> Enterprise Engineering & Analytics(EDF Consolidation Layer)
>
> Data Engineer
>
> ZS @ Amgen Information Systems
>
> [ Working in IST Hours ]
>
> CDL Resolver Group : ENTBI-EDF-CDL-OPS
>
> -----Original Message-----
> From: Roy, Adrija <aro...@amgen.com>
> Sent: Thursday, September 18, 2025 10:44 PM
> To: Jadia, Shailesh <sja...@amgen.com>; Aynlender, Sandra
> <aayn...@amgen.com>; Sharma, Praydeep <psha...@amgen.com>
> Cc: EDF CDL Support Team <EDF-CDL...@amgen.com>; Chakraborty,
> Ayontika <acha...@amgen.com>; Doma, Nanditha <nd...@amgen.com>; Vemula,
> Anil Kumar <avem...@amgen.com>; Home, David <dh...@amgen.com>;
> Gangadhare, Aakash <aak...@amgen.com>; edfsemantic-support
> <edfsemant...@amgen.com>
> Subject: RE: Geonames pipeline failure due to source URL : INC2958573
> Importance: High
>
> Hi @Jadia, Shailesh,
>
> As mentioned below, the subscription to Geonames site has expired and
> hence require further renewal.
>
> @FYI - @Aynlender, Sandra/@Sharma, Praydeep
>
> With Best Regards,
>
> Adrija Roy
>
> Enterprise Engineering & Analytics(EDF Consolidation Layer) Data
> Engineer Certified SAFe 5 Practitioner TCS @ Amgen Information Systems [
> Working in EST Hours ]
>
> Cell: +1-416.835.6328 | aro...@amgen.com <mailto:aro...@amgen.com> CDL
> Resolver Group : ENTBI-EDF-CDL-OPS
>
> Learn more about Enterprise Data Fabric :
>
> Enterprise Data Fabric
>
> Near future planned leaves < 12th Nov – 26th Nov >
>
> -----Original Message-----
>
> From: Marc Wick <ma...@geonames.org <mailto:ma...@geonames.org>>
>
> Sent: September 18, 2025 11:25 AM
>
> To: Doma, Nanditha <nd...@amgen.com <mailto:nd...@amgen.com>>; Vemula,
> Anil Kumar <avem...@amgen.com <mailto:avem...@amgen.com>>; Home, David
> <dh...@amgen.com <mailto:dh...@amgen.com>>; Aynlender, Sandra
> <aayn...@amgen.com <mailto:aayn...@amgen.com>>; in...@geonames.org
> <mailto:in...@geonames.org>; geon...@googlegroups.com
> <mailto:geon...@googlegroups.com>
>
> Cc: EDF CDL Support Team <EDF-CDL...@amgen.com
> <mailto:EDF-CDL...@amgen.com>>; Chakraborty, Ayontika
> <acha...@amgen.com <mailto:acha...@amgen.com>>
>
> Subject: Re: Geonames pipeline failure due to source URL : INC2958573
>
> EXTERNAL: Use caution with unknown senders

>
> Hi Nanditha
>
> Your subscription has expired. The html page is telling you this.
>
> Please prolong the subscription to re-enable access.
>
> Best Regards
>
> Marc
>
> Doma, Nanditha wrote:
>
>> HI @Vemula, Anil Kumar <mailto:avem...@amgen.com>/@Home, David
>
>> <mailto:dh...@amgen.com>/@Aynlender, Sandra
>
>> <mailto:aayn...@amgen.com>,
>
>>
>
>> We have observed that, the geonames pipeline
>
>> (edf_microbatch_ingestion_geonames_prd)  has failed with the below error:
>
>>
>
>> We have done our initial analysis and identified that the data read
>

>> from the URL -
>
>> '*https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.geonames.org%2Fpremiumdata%2Flatest%2F&data=05%7C02%7Cndoma%40amgen.com%7C5f2b7220424644e348ce08ddf6d6bd34%7C4b4266a6136841afad5a59eb634f7ad8%7C0%7C0%7C638938124389764253%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=X1alVmDOdM71mHKA84BPbiFNpTemGaQc0p%2Fo6UCqQJw%3D&reserved=0<table_name>.<txt>/<zip>*'

[Marc Wick]

Hi Nanditha

Oh, you are using http. It has been fixed for http now.
Can you recheck?
Sorry about the inconvenience.

Best Regards

Marc

Doma, Nanditha wrote:

> Hi @Marc Wick,
>
> Please be informed that our CDL job for Geonames is still failing with the same error message. We are connecting to Geonames using the following base URL:
>
> URL: http://www.geonames.org/premiumdata/latest/
>
> However, the content returned from this URL is in HTML format instead of the expected Tab-delimited format.
>
> Could you please investigate this issue and assist us further? And let us know if any additional information is required .

>
>
> Thanks and Regards,
> Nanditha Doma
> Enterprise Engineering & Analytics(EDF Consolidation Layer)
> Data Engineer
> ZS @ Amgen Information Systems
> [ Working in IST Hours ]
> CDL Resolver Group : ENTBI-EDF-CDL-OPS
>
>
>
> -----Original Message-----
> From: Doma, Nanditha <nd...@amgen.com>
> Sent: Monday, November 17, 2025 3:51 PM
> To: Marc Wick <ma...@geonames.org>; in...@geonames.org; geon...@googlegroups.com; Home, David <dh...@amgen.com>
> Cc: EDF CDL Support Team <EDF-CDL...@amgen.com>; Chakraborty, Ayontika <acha...@amgen.com>; Aynlender, Sandra <aayn...@amgen.com>; Jaladi, Rajendra <rja...@amgen.com>; Kaki, Kiran Kumar <kk...@amgen.com>; Vemula, Anil Kumar <avem...@amgen.com>
> Subject: RE: Geonames pipeline failure due to source URL : INC2958573
>

> Hi @Marc Wick,
>
> We will check and keep you posted.

>
> Thanks and Regards,
> Nanditha Doma
> Enterprise Engineering & Analytics(EDF Consolidation Layer) Data Engineer ZS @ Amgen Information Systems [ Working in IST Hours ] CDL Resolver Group : ENTBI-EDF-CDL-OPS
>
>
>
> -----Original Message-----
> From: Marc Wick <ma...@geonames.org>
> Sent: Monday, November 17, 2025 3:41 PM
> To: Doma, Nanditha <nd...@amgen.com>; in...@geonames.org; geon...@googlegroups.com; Home, David <dh...@amgen.com>
> Cc: EDF CDL Support Team <EDF-CDL...@amgen.com>; Chakraborty, Ayontika <acha...@amgen.com>; Aynlender, Sandra <aayn...@amgen.com>; Jaladi, Rajendra <rja...@amgen.com>; Kaki, Kiran Kumar <kk...@amgen.com>; Vemula, Anil Kumar <avem...@amgen.com>
> Subject: Re: Geonames pipeline failure due to source URL : INC2958573
>
> EXTERNAL: Use caution with unknown senders
>
>
> Hi Nanditha
>

> It should be fixed. Can you recheck?
>
> Background: we had slow ssl connections on the www server and had moved to a backup server. Because of an error in the config oct and nov have not been displayed from the backup server.
>
> Best Regards
>
> Marc
>
> Doma, Nanditha wrote:
>> Hi Team,
>>
>> Geonames pipeline in CDL has been failed with the below error message
>> "*The number of columns doesn't match". * Please find the snapshot for
>> more details.
>>
>> We have done our initial analysis and identified that the data read

>> from the URL -
>> '*http://www.geonames.org/premiumdata/latest/<table_name>.<txt>/<zip>*'

>> Near future planned leaves < 12th Nov - 26th Nov >

>>> '*http://www.geonames.org/premiumdata/latest/<table_name>.<txt>/<zip>*'