[teiid-issues] [JBoss JIRA] (TEIID-4342) loadMatView afterLoadScript error when calling a function
Steven Hawkins (JIRA)
issues at jboss.org
Fri Jul 15 15:07:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-4342:
----------------------------------
Component/s: Query Engine
Fix Version/s: 9.1
9.0.2
Priority: Critical (was: Major)
> loadMatView afterLoadScript error when calling a function
> ----------------------------------------------------------
>
> Key: TEIID-4342
> URL: https://issues.jboss.org/browse/TEIID-4342
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 9.1, 9.0.2
>
>
> I'm using Teiid 9.0.0
> Here is the afterloadscript:
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute implify_dataModel.native(''ALTER TABLE "implify_data"."User" RENAME TO "implify_data"."User_temp"'');execute implify_dataModel.native(''ALTER TABLE "implify_data"."User_stage" RENAME TO "implify_data"."User"'');execute implify_dataModel.native(''ALTER TABLE "implify_data"."User_temp" RENAME TO "implify_data"."User_stage"'');execute implify_dataModel.native(''truncate table "implify_data"."User_stage"''); SELECT ON_VIEW_LOADED_COMPLETE(''VIEW.B7F553FA-4F52-45FE-82BD-E2C18A4658B2.User'') '
> the call of the following function is causing the exception, but i did not find the log file where the exception is written
> SELECT ON_VIEW_LOADED_COMPLETE(''VIEW.B7F553FA-4F52-45FE-82BD-E2C18A4658B2.User'')
> if I put the function into ON_VDB_DROP_SCRIPT, it is called successfully
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list