Skip Menu |

This queue is for tickets about the WWW-Salesforce CPAN distribution.

Report information
The Basics
Id: 68831
Status: resolved
Priority: 0/
Queue: WWW-Salesforce
People
Owner: Nobody in particular
Requestors: uwe.bartels [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed Jun 15 12:49:48 2011 uwe.bartels [...] gmail.com - Ticket created
Subject: problem with user table
Date: Wed, 15 Jun 2011 18:49:40 +0200
To: bug-WWW-Salesforce [...] rt.cpan.org
From: Uwe Bartels <uwe.bartels [...] gmail.com>
Hi Fred, I have a strange problem with the perl module WWW::Salesforce. I'm migrating a windows job which exports salesforce data via apex dataloader to perl. I have exports for some tables running fine, but I have problems with the User table. I get the error message below. The same query runs fine with apex data loader with the same account. Do have any idea what's wrong? With my account I'm supposed to see all data, but I don't have admin privileges. the get_fields.pl example script does not show this column neither. Error running query against User table: INVALID_FIELD: Phone, Fax, MobilePhone, Alias, CommunityNickname, IsActive, TimeZoneSidKey ^ ERROR at Row:1:Column:172 No such column 'CommunityNickname' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. at /usr/local/share/perl/5.10.1/WWW/Salesforce.pm line 548. Best Regards, Uwe
  Wed Jun 15 13:05:10 2011 fred [...] redhotpenguin.com - Correspondence added
Subject: Re: [rt.cpan.org #68831] problem with user table
Date: Wed, 15 Jun 2011 10:05:00 -0700
To: bug-WWW-Salesforce [...] rt.cpan.org
From: Fred Moyer <fred [...] redhotpenguin.com>
I would suggest trying __c as the error message suggests. "If you are attempting to use a custom field, be sure to append the '__c' after the custom field name." On Wed, Jun 15, 2011 at 9:49 AM, Uwe Bartels via RT <bug-WWW-Salesforce@rt.cpan.org> wrote: Show quoted text
> Wed Jun 15 12:49:48 2011: Request 68831 was acted upon. > Transaction: Ticket created by uwe.bartels@gmail.com >       Queue: WWW-Salesforce >     Subject: problem with user table >   Broken in: (no value) >    Severity: (no value) >       Owner: Nobody >  Requestors: uwe.bartels@gmail.com >      Status: new >  Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=68831 > > > > Hi Fred, > > I have a strange problem with the perl module WWW::Salesforce. > I'm migrating a windows job which exports salesforce data via apex > dataloader to perl. > I have exports for some tables running fine, but I have problems with the > User table. > > > I get the error message below. The same query runs fine with apex data > loader with the same account. Do have any idea what's wrong? > With my account I'm supposed to see all data, but I don't have admin > privileges. > the get_fields.pl example script does not show this column neither. > > Error running query against User table: INVALID_FIELD: > Phone, Fax, MobilePhone, Alias, CommunityNickname, IsActive, TimeZoneSidKey >                                ^ > ERROR at Row:1:Column:172 > No such column 'CommunityNickname' on entity 'User'. If you are attempting > to use a custom field, be sure to append the '__c' after the custom field > name. Please reference your WSDL or the describe call for the appropriate > names. at /usr/local/share/perl/5.10.1/WWW/Salesforce.pm line 548. > > > Best Regards, > Uwe > >
  Wed Jun 15 13:05:11 2011 The RT System itself - Status changed from 'new' to 'open'
  Wed Jun 15 13:12:22 2011 uwe.bartels [...] gmail.com - Correspondence added
Subject: Re: [rt.cpan.org #68831] problem with user table
Date: Wed, 15 Jun 2011 19:12:12 +0200
To: bug-WWW-Salesforce [...] rt.cpan.org
From: Uwe Bartels <uwe.bartels [...] gmail.com>
Hi Fred, this is definitely not a custom field and this select statement runs fine on apexdataloder with the same login. best regards, Uwe On 15 June 2011 19:05, fred@redhotpenguin.com via RT < bug-WWW-Salesforce@rt.cpan.org> wrote: Show quoted text
> <URL: http://rt.cpan.org/Ticket/Display.html?id=68831 > > > I would suggest trying __c as the error message suggests. > > "If you are attempting to use a custom field, be sure to append the > '__c' after the custom field name." > > On Wed, Jun 15, 2011 at 9:49 AM, Uwe Bartels via RT > <bug-WWW-Salesforce@rt.cpan.org> wrote:
> > Wed Jun 15 12:49:48 2011: Request 68831 was acted upon. > > Transaction: Ticket created by uwe.bartels@gmail.com > > Queue: WWW-Salesforce > > Subject: problem with user table > > Broken in: (no value) > > Severity: (no value) > > Owner: Nobody > > Requestors: uwe.bartels@gmail.com > > Status: new > > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=68831 > > > > > > > Hi Fred, > > > > I have a strange problem with the perl module WWW::Salesforce. > > I'm migrating a windows job which exports salesforce data via apex > > dataloader to perl. > > I have exports for some tables running fine, but I have problems with the > > User table. > > > > > > I get the error message below. The same query runs fine with apex data > > loader with the same account. Do have any idea what's wrong? > > With my account I'm supposed to see all data, but I don't have admin > > privileges. > > the get_fields.pl example script does not show this column neither. > > > > Error running query against User table: INVALID_FIELD: > > Phone, Fax, MobilePhone, Alias, CommunityNickname, IsActive,
> TimeZoneSidKey
> > ^ > > ERROR at Row:1:Column:172 > > No such column 'CommunityNickname' on entity 'User'. If you are
> attempting
> > to use a custom field, be sure to append the '__c' after the custom field > > name. Please reference your WSDL or the describe call for the appropriate > > names. at /usr/local/share/perl/5.10.1/WWW/Salesforce.pm line 548. > > > > > > Best Regards, > > Uwe > > > >
> >
  Thu Jun 16 09:33:55 2011 uwe.bartels [...] gmail.com - Correspondence added
Subject: Re: [rt.cpan.org #68831] problem with user table
Date: Thu, 16 Jun 2011 15:33:42 +0200
To: bug-WWW-Salesforce [...] rt.cpan.org
From: Uwe Bartels <uwe.bartels [...] gmail.com>
Hi Fred, I changed the api version in the perl module from 8.0 to 21.0 nd now it works. I don't know of course if now any other errors come up. But of course I have to ask if you or somebody else keep track with the changes at salesforce. The features implemented right now in the perl module are however enough for me. I only feel not that safe now that I simply changed the api version without beeing able to test it. best regards, Uwe On 15 June 2011 19:05, fred@redhotpenguin.com via RT < bug-WWW-Salesforce@rt.cpan.org> wrote: Show quoted text
> <URL: http://rt.cpan.org/Ticket/Display.html?id=68831 > > > I would suggest trying __c as the error message suggests. > > "If you are attempting to use a custom field, be sure to append the > '__c' after the custom field name." > > On Wed, Jun 15, 2011 at 9:49 AM, Uwe Bartels via RT > <bug-WWW-Salesforce@rt.cpan.org> wrote:
> > Wed Jun 15 12:49:48 2011: Request 68831 was acted upon. > > Transaction: Ticket created by uwe.bartels@gmail.com > > Queue: WWW-Salesforce > > Subject: problem with user table > > Broken in: (no value) > > Severity: (no value) > > Owner: Nobody > > Requestors: uwe.bartels@gmail.com > > Status: new > > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=68831 > > > > > > > Hi Fred, > > > > I have a strange problem with the perl module WWW::Salesforce. > > I'm migrating a windows job which exports salesforce data via apex > > dataloader to perl. > > I have exports for some tables running fine, but I have problems with the > > User table. > > > > > > I get the error message below. The same query runs fine with apex data > > loader with the same account. Do have any idea what's wrong? > > With my account I'm supposed to see all data, but I don't have admin > > privileges. > > the get_fields.pl example script does not show this column neither. > > > > Error running query against User table: INVALID_FIELD: > > Phone, Fax, MobilePhone, Alias, CommunityNickname, IsActive,
> TimeZoneSidKey
> > ^ > > ERROR at Row:1:Column:172 > > No such column 'CommunityNickname' on entity 'User'. If you are
> attempting
> > to use a custom field, be sure to append the '__c' after the custom field > > name. Please reference your WSDL or the describe call for the appropriate > > names. at /usr/local/share/perl/5.10.1/WWW/Salesforce.pm line 548. > > > > > > Best Regards, > > Uwe > > > >
> >
  Thu Jun 16 09:35:30 2011 fred [...] redhotpenguin.com - Correspondence added
Subject: Re: [rt.cpan.org #68831] problem with user table
Date: Thu, 16 Jun 2011 06:35:14 -0700
To: bug-WWW-Salesforce [...] rt.cpan.org
From: Fred Moyer <fred [...] redhotpenguin.com>
Oh nice - can you post the exact change you made? On Thu, Jun 16, 2011 at 6:33 AM, Uwe Bartels via RT <bug-WWW-Salesforce@rt.cpan.org> wrote: Show quoted text
>       Queue: WWW-Salesforce >  Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=68831 > > > Hi Fred, > > I changed the api version in the perl module from 8.0 to 21.0 nd now it > works. > > I don't know of course if now any other errors come up. But of course I have > to ask if you or somebody else keep track with the changes at salesforce. > The features implemented right now in the perl module are however enough for > me. I only feel not that safe now that I simply changed the api version > without beeing able to test it. > > best regards, > Uwe > > On 15 June 2011 19:05, fred@redhotpenguin.com via RT < > bug-WWW-Salesforce@rt.cpan.org> wrote: >
>> <URL: http://rt.cpan.org/Ticket/Display.html?id=68831 > >> >> I would suggest trying __c as the error message suggests. >> >> "If you are attempting to use a custom field, be sure to append the >> '__c' after the custom field name." >> >> On Wed, Jun 15, 2011 at 9:49 AM, Uwe Bartels via RT >> <bug-WWW-Salesforce@rt.cpan.org> wrote:
>> > Wed Jun 15 12:49:48 2011: Request 68831 was acted upon. >> > Transaction: Ticket created by uwe.bartels@gmail.com >> >       Queue: WWW-Salesforce >> >     Subject: problem with user table >> >   Broken in: (no value) >> >    Severity: (no value) >> >       Owner: Nobody >> >  Requestors: uwe.bartels@gmail.com >> >      Status: new >> >  Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=68831 > >> > >> > >> > Hi Fred, >> > >> > I have a strange problem with the perl module WWW::Salesforce. >> > I'm migrating a windows job which exports salesforce data via apex >> > dataloader to perl. >> > I have exports for some tables running fine, but I have problems with the >> > User table. >> > >> > >> > I get the error message below. The same query runs fine with apex data >> > loader with the same account. Do have any idea what's wrong? >> > With my account I'm supposed to see all data, but I don't have admin >> > privileges. >> > the get_fields.pl example script does not show this column neither. >> > >> > Error running query against User table: INVALID_FIELD: >> > Phone, Fax, MobilePhone, Alias, CommunityNickname, IsActive,
>> TimeZoneSidKey
>> >                                ^ >> > ERROR at Row:1:Column:172 >> > No such column 'CommunityNickname' on entity 'User'. If you are
>> attempting
>> > to use a custom field, be sure to append the '__c' after the custom field >> > name. Please reference your WSDL or the describe call for the appropriate >> > names. at /usr/local/share/perl/5.10.1/WWW/Salesforce.pm line 548. >> > >> > >> > Best Regards, >> > Uwe >> > >> >
>> >>
> >
  Thu Jun 16 10:21:40 2011 uwe.bartels [...] gmail.com - Correspondence added
Subject: Re: [rt.cpan.org #68831] problem with user table
Date: Thu, 16 Jun 2011 16:21:25 +0200
To: bug-WWW-Salesforce [...] rt.cpan.org
From: Uwe Bartels <uwe.bartels [...] gmail.com>
change the string 8.0 to 21.0 in the very top of the Salesforce.pm. sorry for the short answer, but I'm just about to leave the office. Uwe On 16 June 2011 15:35, fred@redhotpenguin.com via RT < bug-WWW-Salesforce@rt.cpan.org> wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=68831 > > > Oh nice - can you post the exact change you made? > > On Thu, Jun 16, 2011 at 6:33 AM, Uwe Bartels via RT > <bug-WWW-Salesforce@rt.cpan.org> wrote:
> > Queue: WWW-Salesforce > > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=68831 > > > > > Hi Fred, > > > > I changed the api version in the perl module from 8.0 to 21.0 nd now it > > works. > > > > I don't know of course if now any other errors come up. But of course I
> have
> > to ask if you or somebody else keep track with the changes at salesforce. > > The features implemented right now in the perl module are however enough
> for
> > me. I only feel not that safe now that I simply changed the api version > > without beeing able to test it. > > > > best regards, > > Uwe > > > > On 15 June 2011 19:05, fred@redhotpenguin.com via RT < > > bug-WWW-Salesforce@rt.cpan.org> wrote: > >
> >> <URL: http://rt.cpan.org/Ticket/Display.html?id=68831 > > >> > >> I would suggest trying __c as the error message suggests. > >> > >> "If you are attempting to use a custom field, be sure to append the > >> '__c' after the custom field name." > >> > >> On Wed, Jun 15, 2011 at 9:49 AM, Uwe Bartels via RT > >> <bug-WWW-Salesforce@rt.cpan.org> wrote:
> >> > Wed Jun 15 12:49:48 2011: Request 68831 was acted upon. > >> > Transaction: Ticket created by uwe.bartels@gmail.com > >> > Queue: WWW-Salesforce > >> > Subject: problem with user table > >> > Broken in: (no value) > >> > Severity: (no value) > >> > Owner: Nobody > >> > Requestors: uwe.bartels@gmail.com > >> > Status: new > >> > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=68831 > > >> > > >> > > >> > Hi Fred, > >> > > >> > I have a strange problem with the perl module WWW::Salesforce. > >> > I'm migrating a windows job which exports salesforce data via apex > >> > dataloader to perl. > >> > I have exports for some tables running fine, but I have problems with
> the
> >> > User table. > >> > > >> > > >> > I get the error message below. The same query runs fine with apex data > >> > loader with the same account. Do have any idea what's wrong? > >> > With my account I'm supposed to see all data, but I don't have admin > >> > privileges. > >> > the get_fields.pl example script does not show this column neither. > >> > > >> > Error running query against User table: INVALID_FIELD: > >> > Phone, Fax, MobilePhone, Alias, CommunityNickname, IsActive,
> >> TimeZoneSidKey
> >> > ^ > >> > ERROR at Row:1:Column:172 > >> > No such column 'CommunityNickname' on entity 'User'. If you are
> >> attempting
> >> > to use a custom field, be sure to append the '__c' after the custom
> field
> >> > name. Please reference your WSDL or the describe call for the
> appropriate
> >> > names. at /usr/local/share/perl/5.10.1/WWW/Salesforce.pm line 548. > >> > > >> > > >> > Best Regards, > >> > Uwe > >> > > >> >
> >> > >>
> > > >
> >
  Wed May 04 10:18:45 2016 cwhitener [...] gmail.com - Correspondence added
The API version in WWW::Salesforce has been 23 for quite some time now. I'm just closing this ticket out as it's no longer a problem. Thanks, Chase
  Wed May 04 10:18:47 2016 cwhitener [...] gmail.com - Status changed from 'open' to 'resolved'