Skip to main content
Question

Microsoft SQL Server Non-Spatial Writer: Query failed, possibly due to a malformed statement.

  • December 9, 2022
  • 1 reply
  • 202 views
S

Hi,

 

I am new to FME. I am having below error with one our jobs.

I am not sure what is causing the issue because it is intermittent.

Today it will throw an error the next day it is okay.

 

*I have remove the structure of my table*

 

7239 Processing attribute 2 for LEAN or LEAN_AND_MEAN usage

7240 Processed 2 elements with mode CLASSIC

7241 Microsoft SQL Server Non-Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `CREATE TABLE Projects.[Assets] Provider error `(-2147217900) CREATE TABLE permission denied in database 'TT'.'

7242 Microsoft SQL Server Non-Spatial Writer: Failed to create the destination table for feature type `Projects.Assets'

7243 A fatal error has occurred. Check the logfile above for details

7244 ... Last line repeated 2 times ...

7245 2022-12-09 05:03:02| 7.6| 0.0|ERROR |

7246 A fatal error has occurred. Check the logfile above for details

7247 2022-12-09 05:03:02| 7.6| 0.0|ERROR |

1 reply

david_r
Celebrity
  • david_rCelebrity
  • December 9, 2022

Sounds like your user credentials are lacking the necessary permissions in the database. You may want to talk to your database administrator to be sure.

Reply


Helpful Members This Week

Community Stats

31,184
Posts
118,190
Replies
38,794
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.