Skip to main content

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.tAssets] 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 |

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