Home » Developer & Programmer » Forms » Error 408 Occurred [message #117987] New twist
Error 408 Occurred [message #117987] New twist [message #268132] Mon, 17 September 2007 12:42 Go to next message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member
Hi

I have read the responses on this error 408 and am convinced that my situation calls for a different solution than the ones already posted here.

I'm using Forms 6i on 2 environments
1. AIX 5L- > Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
2. Win 2000 Server -> Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production

When I run an authorization process on a form in Windows, I have no problem.
But, when I run the same form while connected to an AIX server, then I get this in Error_text -> Error 408 occurred. See the release notes file (Relnotes) for information about this error.
This actually occurs on processing a second record. The first one executes and commits succesfully.

The authorization procedure is coded in the form as this
--Authorize Document i.e Assign a user to :Master.AuthorizedUser
:Master.AuthorizedUser := :Global.UserId;
:Master.AuthorizedDate := SysDate;

Commit_Form;

:Parameter.FundType := :Master.FundType;
:Parameter.Documentno := :Master.Documentno;
LvOldWhereClause := Get_Block_Property ('Master',Default_Where);
Go_Block('MASTER');
Set_Block_Property('Master',Default_Where,LvOldWhereClause||
' And LinkId = '||''''||LvLinkId||'''');
Execute_query;


The exact same form is working well in a windows environment and I 'm tempted to suspect something to do with AIX environment settings somewhere.In windows I can authorize many records in succession, yet in AIX I can only authorize one and then, afterwards, this message comes and I'll be already disconnected from oracle.(See attached Screenshot).

Thank you in advance for your attention.

M.
  • Attachment: Error 408.png
    (Size: 34.14KB, Downloaded 223 times)
Re: Error 408 Occurred [message #117987] New twist [message #268259 is a reply to message #268132] Tue, 18 September 2007 01:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
From where did 'LvLinkId' come? Please post ALL of the code between 'code' tags, forget the colour, its a waste of time.

David
Re: Error 408 Occurred [message #117987] New twist [message #268351 is a reply to message #268132] Tue, 18 September 2007 05:17 Go to previous messageGo to next message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member
Hi David
Code is:
PROCEDURE DocumentAuthorization IS
  lvValidAuthorizer     VARCHAR2 (1)                          := 'N';
  lvErrMessage          ErrorTable.ErrorMessage%TYPE;
  lvSpace               VARCHAR2 (4)                          := chr (10);
  lvDocsi               Document_hdr.ForeignSumInsured%TYPE   := 0;
  lvSubject             VARCHAR2 (2000);
  lvMessage             VARCHAR2 (4000);
  lvMessageId           VARCHAR2 (30);
  lvCurrentAlertTitle   VARCHAR2 (50);
  lValertNumber         NUMBER;
  lvOldWhereClause      VARCHAR2 (1000)
                                := Get_Block_Property ('MASTER', Default_Where);
  lvNewWhereClause      VARCHAR2 (1000);
  lvLinkId              Document_hdr.LinkId%TYPE              := :Master.LinkId;
  lvValue               VARCHAR2 (4000);   -- Added by Jyothi on 08.04.2006
BEGIN
  IF General_2.CheckForauthOrizerValidation
            (:Global.CompanyCode,
             :Global.UnitCode,
             nvl (:Master.DocumentType, 'POL'),
             :Global.UserId,
             NULL,   --:Master.PackageCode, -- commented by saiphani on 18.07.2005
             :Master.MainClass,
             NULL,   --SubClass,
             0) = 'N' THEN
    --LvDocSI) = 'N' Then
    lValertNumber  := Errors.ShowAlert ('ITEMERRMESG',
                                        '10065',
                                        'ERROR',
                                        :Global.UserId,
                                        NULL);
    Go_Item (:Control.TabViewFirstItem);
    RAISE Form_Trigger_Failure;
  END IF;
  BEGIN
    lvValue  := General_3.GetApplicationValue (:Global.CompanyCode,
                                               :Global.UnitCode,
                                               'IS_AUTHORIZER_MODIFIER');
  EXCEPTION
    WHEN OTHERS THEN
      lvValue  := 'N';
  END;
  IF lvValue = 'Y' THEN
    :Control.ModelIst  := 'Modify';
    :Control.ModeFlag  := :Control.ModelIst;
    ChoiceProc;
  END IF;
  :Master.AuthorizedUser  := :Global.UserId;
  :Master.AuthorizedDate  := SYSDATE;
  CallProcsAfterAuthorization;
  -- Committing the Changes...
  Commit_Form;
  -- Added by Malavika - otherwise all the records will get queried at direct authorizaton after the
  -- Proposal convertion to policy
  :Parameter.FundType     := :Master.FundType;
  :Parameter.DocumentNo   := :Master.DocumentNo;
  lvOldWhereClause        := Get_Block_Property ('Master', Default_Where);
  Go_Block ('MASTER');
  Set_Block_Property ('Master',
                      Default_Where,
                      lvOldWhereClause
                      || ' And LinkId = '
                      || ''''
                      || lvLinkId
                      || '''');
  Execute_Query;
  Set_Block_Property ('Master', Default_Where, lvOldWhereClause);
  -- ReSetting Alert Title to old one
  Set_Alert_Property ('ItemErrMesg', Title, lvCurrentAlertTitle);
  -- Reset values
  :Control.ModelIst       := NULL;
  :Control.ModeFlag       := :Control.ModelIst;
  ChoiceProc;
EXCEPTION
  WHEN OTHERS THEN
    DisplayAlert ('ITEMERRMESG',
                  NULL,
                  'Error in Document Authorization : ' || dbms_Error_Text,
                  '',
                  NULL,
                  lValertNumber);
    Copy ('N', 'Control.CommitLevel');
    Copy ('N', 'Parameter.CommitingFlag');
    RAISE Form_Trigger_Failure;
END;


Lv linkid is assigned from the Database column Linkid at declaration.

Mod-upd: please format your code and use the 'code' tags.

[Updated on: Tue, 18 September 2007 23:31] by Moderator

Report message to a moderator

Re: Error 408 Occurred [message #117987] New twist [message #268502 is a reply to message #268351] Tue, 18 September 2007 23:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please confirm that 'Document_hdr.LinkId' and ':Master.LinkId' are both varchar2 fields.

David
Re: Error 408 Occurred [message #117987] New twist [message #268504 is a reply to message #268502] Tue, 18 September 2007 23:38 Go to previous messageGo to next message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member
Yes they are, actually its like this on the desc
LINKID NOT NULL VARCHAR2(30)
Re: Error 408 Occurred [message #117987] New twist [message #268511 is a reply to message #268504] Tue, 18 September 2007 23:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
And the ':Master.LinkId'?

David
Re: Error 408 Occurred [message #117987] New twist [message #268512 is a reply to message #268511] Tue, 18 September 2007 23:51 Go to previous messageGo to next message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member
Char 30

Mike
Re: Error 408 Occurred [message #117987] New twist [message #268525 is a reply to message #268512] Wed, 19 September 2007 00:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Mike,

The message that you posted in your original post, is that something that your application displayed? What do you get from using 'Help> Display Error'?

David
Re: Error 408 Occurred [message #117987] New twist [message #268535 is a reply to message #268525] Wed, 19 September 2007 00:40 Go to previous messageGo to next message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member
help display Error does not give anything.
The error is displayed according my Message sttmnt in On-Error trigger as below.
I have also attached a video session of the error occuring.
Ignore the messages at the start.

DECLARE
/*****************************************************************************************
 This trigger is used to trap errors generated by forms application.
*****************************************************************************************/
BEGIN
	if not form_success then
			Message('error_text'||error_text||'dbms_error_text'||dbms_error_text||'sqlerrm'||sqlerrm);Pause;
	End if;
	
	DECLARE
		LvMissErr EXCEPTION;
		Pragma    EXCEPTION_INIT(lvMissErr, -20000);
		LvErrNo   NUMBER;
		LvErrType VARCHAR2(20);
		LvErrMesg VARCHAR2(100);
		IdAlert   ALERT := Find_Alert('SYSTEMERROR');
	BEGIN
		If SqlCode = 0 Then
			lvErrNo := Error_Code;
		Else
			lvErrNo := SqlCode;
		End If;

		LvErrMesg := Error_Text ;
--     If :Control.ShowError IN (NULL,'Y') Then  -- manupulating field format mask errors
		If lvErrNo IN (40200,41050) Then
			Message(' Field is protected against update ..', No_Acknowledge);
		ElsIf lvErrNo = 40831 Then
			Message(' ', No_Acknowledge);
		ElsIf lvErrNo = 40203 Then
			Message(' Field Must be Entered Completely..', No_Acknowledge);
		ElsIf lvErrNo = 40207 Then
			Message(' Invalid Range Given ..', No_Acknowledge);
		ElsIf lvErrNo = 40212 THEN
			Message(' Feild Value is Invalid. Pick from List..',No_Acknowledge);
	 	ElsIf LvErrNo In (40105, 41014) Then
        	-- This is for errors arising out of ScreenSettings proc call
        	-- 40105 is for Unable to resolve reference to item
        	-- 41014 is for Cannot set attribute of null canvas item
        	Null; -- This is for set item property(Screen Settings)

	 	Elsif lvErrNo = 0 THEN
			Message(' Unable To Insert Due To Incompatible Data..',No_Acknowledge);
		Else
			/*           Set_Alert_Property(idAlert, Alert_Message_Text, 
               'Error No: ' || To_Char(lvErrNo) || ', Message: ' || lvErrMesg);
           If Show_Alert(idAlert) = Alert_Button1 Then
              Null;
           End If;
			*/
			Message('Error No: ' || To_Char(lvErrNo) || ', Message: ' || lvErrMesg, No_Acknowledge);
		End If;
  --   End If;
		Raise Form_Trigger_Failure;
	EXCEPTION
		WHEN lvMissErr THEN
		/*             Set_Alert_Property(idAlert, Alert_Message_Text, 
                'Error no:' || :global.Err ||
                ' of type:' || :global.Type || 
                ' not defined in the database');
             If Show_Alert(idAlert) = Alert_Button1 Then
                Return;
             End If;*/
		Message('Error no:' || :global.Err || ' of type:' || :global.Type || 
                ' not defined in the database',No_Acknowledge);
	END;
END;

Upd-mod: PLEASE use 'code' tags.

[Updated on: Wed, 19 September 2007 00:47] by Moderator

Report message to a moderator

Re: Error 408 Occurred [message #117987] New twist [message #268538 is a reply to message #268535] Wed, 19 September 2007 00:56 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I can't process the 'rar' file on this PC. Please use 'zip' in future.

Do you have the block's 'DML Returning Value' set to 'no' or 'yes'? Do you have a database trigger that is modifing any of the values that you are changing? Do you have any 'on-insert' or 'on-update' triggers in your code?

David
Re: Error 408 Occurred [message #117987] New twist [message #268546 is a reply to message #268538] Wed, 19 September 2007 01:13 Go to previous messageGo to next message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member
Hi

1.block's 'DML Returning Value' is set to 'No'
2. database trigger that is modifing any of the values that you are changing => None
3. 'on-insert' or 'on-update' Triggers => No, i do not have.

I have attached the form FDGRP013, am attaching the zip session in next post.
  • Attachment: FDGRP013.zip
    (Size: 477.98KB, Downloaded 193 times)
Re: Error 408 Occurred [message #117987] New twist [message #268550 is a reply to message #268546] Wed, 19 September 2007 01:26 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Get onto Metalink and have a look at Note:290178.1

David
Re: Error 408 Occurred [message #117987] New twist [message #268597 is a reply to message #268550] Wed, 19 September 2007 02:39 Go to previous messageGo to next message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member
Hi,

I'm currently unable to access metalink, the password expired and we're trying to get a renewal through our local agent but this may take a while.

Are u able to share the article by an chance ?

Thank you for your kind attention.

Mike
Re: Error 408 Occurred [message #117987] New twist [message #268818 is a reply to message #268597] Wed, 19 September 2007 18:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry but posting slabs of text from Metalink is not supported by this forum and will be removed by the moderators. Doing it multiple times will lead to the poster being banned.

I suggest that you talk with your colleagues and see if one of them may still have access through a previous work location.

Basically, the Metalink entry pertained to Oracle Database 8 but the patches that needed to be applied were to Forms 6i. Please verify that you have EXACTLY the same version of Forms on both environments. It would also be wise to use a version either less than 13 or greater than 16.

David
Re: Error 408 Occurred [message #117987] New twist [message #268870 is a reply to message #268818] Wed, 19 September 2007 23:50 Go to previous message
FLAZ
Messages: 8
Registered: September 2007
Location: Harare
Junior Member

I follow, It's a good policy on metalink material access.

I'm using Forms 6i Patch 17 on both environments.
Actually i'm doing the run from my PC and connecting alternately to Windows and AIX.
Somehow I get disconnected from AIX with that error, but the exact same form and forms builder executes perfectly, connected to Windows database.

Will try getting the latest forms patch and see.

Again many thanks.

Mike
Previous Topic: Forms faq
Next Topic: forms: can compile cannot run
Goto Forum:
  


Current Time: Thu Dec 08 20:03:13 CST 2016

Total time taken to generate the page: 0.06413 seconds