Re: [Reactor for CF] Error when initing new project

Fri, 29 Sep 2006 09:19:38 -0700

Interesting issue. I figured out what it was, it seems the tables must be owned by 'dbo' and not my network username.

On 9/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

If I was in your shoes I'd do a <cfquery datasource="leo">select * from employee</cfquery> and find out why SQL doesn't like the employee table.  Something has changed that you're assuming didn't.

 

Nathan Owen

Web Master

Idaho Department of Environmental Quality

1410 North Hilton Street

Boise , Idaho  83706

(208) 799-4890

[EMAIL PROTECTED]

 

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Kyle Hayes
Sent: Friday, September 29, 2006 9:01 AM
To: [email protected]


Subject: Re: [Reactor for CF] Error when initing new project

 

Yep. Like I said, I am just transitioning this project. It worked perfect on my local server. I literally did a direct DTS of the db in SQL Server to the new SQL Server isntance on this server

On 9/29/06, Doug Hughes <[EMAIL PROTECTED]> wrote:

And does the employee table exist?  (Is it singular like that?)

 

Doug

 

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, September 29, 2006 11:45 AM


To: [email protected]
Subject: RE: [Reactor for CF] Error when initing new project

 

What does your reactor.xml look like?

 

Nathan Owen

Web Master

Idaho Department of Environmental Quality

1410 North Hilton Street

Boise , Idaho  83706

(208) 799-4890

[EMAIL PROTECTED]

 

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Kyle Hayes
Sent: Friday, September 29, 2006 8:43 AM
To: [email protected]
Subject: Re: [Reactor for CF] Error when initing new project

 

It works...that is for the directory problem, no I am receiving this error:




Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'employee'.

The error occurred in \\sw\regionweb\Dev\ANA\c3n\reactor\base\abstractGateway.cfc: line 547

I checked the datasource and it checks out just fine in CFadmin. I also checked the owner of the tables and cf has all the appropriate perms.

On 9/29/06, Kyle Hayes <[EMAIL PROTECTED]> wrote:

I am talking to the server admin to see what he says about it. He doesn't believe that CF has the permissions to do that. I will get back to you to let you know if that is the issue. I am sure you are right, and I was mistaken about it having the correct permissions. My work just recently moved me to this server and so I am still getting used to it. Thanks for your help, Doug.

On 9/29/06, Doug Hughes < [EMAIL PROTECTED]> wrote:

Actually, not \\sw\regionweb\Dev\ANA\c3n\reactor\core, but \\sw\regionweb\Dev\ANA\c3n\reactor\project

 

CF needs to be able to create directories in there and write files.  If it can't you'll get errors.

 

Doug

 

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Doug Hughes
Sent: Friday, September 29, 2006 11:08 AM
To: [email protected]
Subject: RE: [Reactor for CF] Error when initing new project

 

Does the CF process have read/write access to \\sw\regionweb\Dev\ANA\c3n\reactor\core?

 

 

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Kyle Hayes
Sent: Friday, September 29, 2006 11:01 AM
To: [email protected]
Subject: [Reactor for CF] Error when initing new project

 

I recently had to move my project to a new CF server and received the following error in the ObjectTranslator.cfc:


The specified Directory attribute value \\sw\regionweb\Dev\ANA\c3n\reactor\core\../project/aiwoc/Record/ could not be created.


The error occurred in \\sw\regionweb\Dev\ANA\c3n\reactor\core\objectTranslator.cfc: line 246
Called from \\sw\regionweb\Dev\ANA\c3n\reactor\core\objectTranslator.cfc: line 62
Called from \\sw\regionweb\Dev\ANA\c3n\reactor\core\objectTranslator.cfc: line 28
Called from \\sw\regionweb\Dev\ANA\c3n\reactor\core\objectFactory.cfc: line 132
Called from \\sw\regionweb\Dev\ANA\c3n\reactor\reactorFactory.cfc: line 26
Called from \\sw\regionweb\Dev\ANA\c3n\leo\aiwoc\Application.cfc: line 30

244 :          



















 

 




















 

 
245 :          <cfif NOT DirectoryExists(directory)>




















 

 




















 

 

246 :                  <cfdirectory action="" directory="#getDirectoryFromPath(

 










arguments.path)#" />





















 

 




















 

 
247 :          </cfif>

 

 




















 

 




















 

 
248 :   </cffunction>



















 

 




















 

 




















 

 




















 

 
Any help would be appreciated!




-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

 



-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --



-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Reply via email to