|
|
 |
This question is not answered.
Helpful answers available: 2.
Answered answers available: 1.
|
|
Replies:
9
-
Pages:
1
-
Last Post:
Sep 17, 2009 8:25 PM
by: gregjcooper_500
|
|
|
Posts:
4
Registered:
10/1/08
|
|
|
|
Post Installation Error
Posted:
Oct 1, 2008 10:09 AM
|
|
|
After installing Quest CodeGen, I am unable to generate any scripts. I can launch codebar but the tables are not selectable from the drop down for my schema. Also after closing quest code gen utility, I receive an application error (Access violation at address 7c918fea) that I would be happy to email someone.
Thanks for any help.
Chris
|
|
|
Posts:
57
Registered:
1/23/07
|
|
|
|
Re: Post Installation Error
Posted:
Oct 1, 2008 11:29 AM
in response to: Chris Perren
|
|
|
I think the problem is in the fact that the user holding the CodeGencode doesn't have the rights to use utl_file. Connect as a sysadmin,grant execute on utl_file to <user> and then reinstall thebackend code. You might want to uninstall the current code, but makesure you install into the existing schema.
Hope this helps,
Kindest regards,
Patrick
|
|
|
Posts:
4
Registered:
10/1/08
|
|
|
|
Re: Post Installation Error
Posted:
Oct 1, 2008 1:07 PM
in response to: patch
|
|
|
I did "grant execute on utl_file to codegen" and still no luck. It appears that application violation error is not the main problem but just a side effect when closing the the GUI. I did a new install on a new system and still can't generate any scripts although the application violation disappeared. When I try to generate the scripts, I recieve the below error on both systems. Unfornuately, I'm a java developer trying to learn PL/SQL and the below error message is greek to me.
ORA-01480: trailing null missing from STR bind value
- Also I don't understand if need to install codegen into my current schema "migration" or just have it create a new schema "codegen" of it own and select the synonyn option. Basically I just want to use codegen against my "migration" schema but I prefer it does not install into it if possible.
Again, thanks for the help
|
|
|
Posts:
57
Registered:
1/23/07
|
|
|
|
Re: Post Installation Error
Posted:
Oct 1, 2008 9:11 PM
in response to: Chris Perren
|
|
|
What is your exact environment? I think I remember the STR issue happening when using a certain version of 10G XE, but I am not sure.
I would install Codegen into its own schema and have the synonyms in place so I can access it from anywhere in my database.
Kindest regards,
Patrick
|
|
|
Posts:
4
Registered:
10/1/08
|
|
|
|
Re: Post Installation Error
Posted:
Oct 2, 2008 7:56 AM
in response to: patch
|
|
|
Oracle 10G - 10.2.0.1.1 - I have install codegen on both a Windows XP and Window 2003 server environment and both basically have the same errors. During both installations, I selected to create its own schema "codegen" from the system/manager account plus synonm table. Afterward the installation completed, I attempt to generate the scripts and it fails.
Also I have tried logging in as sysdba from the codegen UI and my tables do show up but the scripts still fail to generate.
One other thing, I'm using oracle sqldeveloper as my IDE which hopefully is not causing any problems.
Overall, I believe the codegen tool to be highly benefitual if I can get it working. I have complete control over my database and their environments and would be happy to try anything on them.
Hopefully I can get this going soon, since I have a large ETL project deadlines approaching.
Thanks for all the help.
Chris Perren
|
|
|
Posts:
4
Registered:
10/1/08
|
|
|
|
Re: Post Installation Error -
Posted:
Oct 3, 2008 8:34 AM
in response to: Chris Perren
|
|
|
It appears this problem occur often ... Hopefully it gets resolved
http://codegen.inside.quest.com/thread.jspa?messageID=19391&tstart=0
|
|
|
Posts:
3
Registered:
9/12/09
|
|
|
|
Re: Post Installation Error
Posted:
Sep 12, 2009 2:48 AM
in response to: Chris Perren
|
|
|
I've nowtried version 1.5.1 and 1.6 QCGU on Windows XP and Oracle 11.1.0.7 and am still getting this same problem.
Is there anyone who can help with this issue please????
Greg Cooper
|
|
|
Posts:
108
Registered:
11/4/06
|
|
|
|
Re: Post Installation Error
Posted:
Sep 15, 2009 2:21 PM
in response to: gregjcooper_500
|
|
|
Greg,
I am very sorry that I have not given you any assistance. Unfortunately, this is a freeware product and we have no free time to work on this at the moment. I am using Codegen on 11.1 without difficulty, so I am not sure what the problem might be. Can you provide more of the error stack, perhaps showing where the error was raised?
Regards, Steven
|
|
|
Posts:
3
Registered:
9/12/09
|
|
|
|
Re: Post Installation Error
Posted:
Sep 15, 2009 11:39 PM
in response to: Chris Perren
|
|
|
Steven,
There is nothing in the call stack or the error stack just
---
declare
USE_QNXO_DEPLOY_IN boolean := sys.diutil.int_to_bool(:USE_QNXO_DEPLOY_IN);
RUN_IN_BKGR boolean := sys.diutil.int_to_bool(:RUN_IN_BKGR);
OBJECTS_REQUIRED_IN boolean := sys.diutil.int_to_bool(:OBJECTS_REQUIRED_IN);
OBJECTS_OVERRIDE_IN boolean := sys.diutil.int_to_bool(:OBJECTS_OVERRIDE_IN);
SAVE_AS_EXAMPLE_IN boolean := sys.diutil.int_to_bool(:SAVE_AS_EXAMPLE_IN);
begin
IF qnxo_runtime.trace_enabled THEN
qnxo_runtime.start_execution(program_name_in => :fe_program_name_in
, information_in => :fe_information_in
);
END IF;
SW_APPLY.RUN_TASK_GRP
(
TASK_GRP_ID_IN => :TASK_GRP_ID_IN
,
USE_QNXO_DEPLOY_IN => USE_QNXO_DEPLOY_IN
,
RUN_IN_BKGR => RUN_IN_BKGR
,
OBJECTS_REQUIRED_IN => OBJECTS_REQUIRED_IN
,
OBJECTS_OVERRIDE_IN => OBJECTS_OVERRIDE_IN
,
OWNER_IN => :OWNER_IN
,
OBJECT_NAME_IN => :OBJECT_NAME_IN
,
OBJECT_TYPE_IN => :OBJECT_TYPE_IN
,
STARTS_WITH_IN => :STARTS_WITH_IN
,
ENDS_WITH_IN => :ENDS_WITH_IN
,
CONTAINS_IN => :CONTAINS_IN
,
REGEXP_IN => :REGEXP_IN
,
EXCLUDE_CONTAINS_IN => :EXCLUDE_CONTAINS_IN
,
EXCLUDE_REGEXP_IN => :EXCLUDE_REGEXP_IN
,
AND_WHERE_FREEFORM_IN => :AND_WHERE_FREEFORM_IN
,
OBJECT_LIST_IN => :OBJECT_LIST_IN
,
ALIAS_LIST_IN => :ALIAS_LIST_IN
,
SETUP_SCRIPT_LIST_IN => :SETUP_SCRIPT_LIST_IN
,
ITEM_DELIM_IN => :ITEM_DELIM_IN
,
PART_DELIM_IN => :PART_DELIM_IN
,
SAVE_AS_EXAMPLE_IN => SAVE_AS_EXAMPLE_IN
,
TASK_RUN_ID_OUT => :TASK_RUN_ID_OUT
);
IF qnxo_runtime.trace_enabled THEN
qnxo_runtime.end_execution(information_in => :fe_information_in);
END IF;
end;
in the Environment window
and the ORA-1480 error message inthe Error Details window.
HTH
Greg
|
|
|
Posts:
3
Registered:
9/12/09
|
|
|
|
Re: Post Installation Error
Posted:
Sep 17, 2009 8:25 PM
in response to: Chris Perren
|
|
|
I have since tried this against a 10.2.0.4 database and it works fine when I generate the PL/SQL code library.
I guess it must be to do with my particular setups for 11.1.
Back to the drawing board again...
Greg
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
|
|
