This project is read-only.
1
Vote

Timer job fails with "Invalid number value"

description

Hello, awesome idea!
 
But on my staging farm, the job fails with "Invalid number value. A number field contains invalid data. Please check the value and try again." The list i specified didn't get created.
 
Tried to put the farm account farm admin, same issue.
 
Any idea?

comments

deafknight wrote Oct 6, 2011 at 10:36 AM

edit : there's an error in the system log, DCOM was unable to communicate with the computer "smtp.xxx" using any of the configured protocols.
Seems the Smtp server makes the job crash. IT has, ofc, no service running.

cf the servers in farm page :

SMTP.xxxx Not Configured
No Action Required Remove Server
SRS-SQL-xxx Microsoft SharePoint Foundation Database
No Action Required Remove Server

deafknight wrote Oct 6, 2011 at 11:00 AM

Update 2 : removing the smtp "server" from the list enables the creation of the list, but it is filled with only one line (the "farm" object level)

I suspect the job now crashes on the database server, because i have still the error "Invalid number value. A number field contains invalid data" (the dcom error with smtp is gone)

AravindKS wrote Oct 13, 2011 at 5:40 PM

Can you try two things.
  1. Change the list data type for numeric fields to text type. This should solve the data type error.
  2. Can you configure the SharePoint Timer Job windows service to run with domain admin credentials. By default, it will be running with that credentials only but still you can confirm it.
This should solve your problem at any cost.

deafknight wrote Oct 14, 2011 at 9:15 AM

Hi and thanks for the update.
Settings the columns to text made "Service account is not authorized" messages appears in free space and memory used columns. From there, elevating the farm account to local admin did solve the problem (stands to reason).

Now, the only problem left is those text values don't get interpreted as numbers in the visio addin! the cpu usage for example stays at 0%.
Will try putting the ones containing correct values to numeric once again.

I'd suggest using "0" or "-1" instead of a literal value in numeric columns :)

deafknight wrote Oct 14, 2011 at 10:19 AM

I can now generate the graphic in visio, but cpu, memory and free space stay at zero in it. (the data is ok)
Does this come from the "text" type change of the data columns?

deafknight wrote Oct 14, 2011 at 10:41 AM

to be more precise, the diagram itself doesnt get updated. But if i drag and drop a line from the data at the bottom, it displays ok.

I must admit i don't know visio enough to know what's wrong

wrote Feb 14, 2013 at 2:39 AM