User:Tspc

From AdempiereWiki

Jump to: navigation, search
Tony's User Boxes
Name This user real name is : Tony Snook
This user has a Sourceforge account.


Contents

[edit]

Introduction

  • My name is Tony Snook and I am from Melbourne, Australia.
  • For the last 14 years I have been employed as the IT Manager for a company that manufactures scientific equipment. Before this I mainly worked as a C Programmer, writing software for embedded systems, Windows and DOS.
  • I have been following the development of Compiere/Adempiere over the last few years and had hoped to implement it at our organization. But due to a lack of resources, the project had to be postponed.
  • I have some experience with Java, Oracle, Postgresql, Redhat Enterprise Server, Fedora, WinXP, Kettle(Pentaho). In the past 12 months I have posted several bugs/solutions and answered questions in forums.
  • My involvement with Adempiere is both as a hobby and some self-education, as I would like to gradually venture back into a programming/developer career.
[edit]

Applying Migration Scripts

The appears to be a number of issues with the current methods of applying migration scripts.

  • Current methods
    • Manually applying each script using tools like
      • (for Oracle) sqlplus, toad, sqldeveloper, ....
      • (for PostgreSQL) psql, pgAdmin, ....
    • Using the ant build scripts which make use of sqlplus for Oracle and psql for PostgreSQL

Problems Include:

  • large number of migration scripts and their size 
 makes it difficult to notice that an error has occured
  • error handling varies depending on the tool and database used 
 SQLPLUS does not return an error code for any SQLPLUS (SP2-xxx) errors
  • rolling back after errors 
 need to ensure that only completely successful scripts are applied and the partially completed script is rolled back.
  • reporting errors 
 person applying the script must be notified that an error has occurred
  • keeping track of which scripts have been applied 
 records need to be kept of which scripts have been applied to the current installation
  • how migration scripts are corrected 
 -correcting a script once it has been committed to trunk can cause problems if someone has already applied the script
 -in some cases it is necessary to apply a script to undo the change and then apply the correct script


[edit]

PL/Java

[edit]

PL/Java Info

(Tested on Fedora 7 (Linux), and Postgresql 8.2.6, PL/Java 1.3.0)

Recent security releases, of Postgresql, have altered the API for SetUserId to include an additional parameter indicating if we're in a security definer context.

  • If you are running any of the following postgresql releases, then you need to upgrade PL/Java
    • 8.0.x where x >= 15
    • 8.1.x where x >= 11
    • 8.2.x where x >= 6 (I needed it and I am running 8.2.5-11) Joseph.brower 11:52, 18 January 2008 (EST)
    • 8.3.x where x >= 0
  • Goto PL/Java CVS Information and check out the latest CVS of PL/Java.
    • Once you have the source, simply build the source with the 'make' comand.
  • If you are upgrading from pljava 1.3.0, then this is a minor upgrade.
  • I simply copied the binaries over the top of the existing installation. 
 cp /build/pljava.jar /usr/var/lib/pljava/
 cp /build/deployer.jar /usr/var/lib/pljava/
 cp /build/objs/pljava.so /usr/var/lib/pljava/
  • su to postgres and restart postgresql 
 su - postgres
 pg_ctl stop
 pg_ctl start
 exit
  • Your PL/Java should now be updated.
[edit]

PL/Java Problems

  • If you are having problems with PL/Java, please check the following: 
 Your postgresql.conf should contain the following lines:
 dynamic_library_path = '\$libdir:/usr/lib/pljava' 
 custom_variable_classes = 'pljava' 
 pljava.classpath = '/usr/lib/pljava/pljava.jar'
 
 Where /usr/lib/pljava is the path to your PL/Java installation (on some systems /opt/pljava ) and contains the following files: 
 deploy.jar
 install.sql
 pljava.jar
 pljava.so
 uninstall.sql
[edit]

PL/Java Links

[edit]

Adempiere350 Branch

[edit]

350 Tasks, Issues And Observations

  • Libero Manufacturing installation documentation out of date and needs to be revised.
    • Need to update Wiki so people don't continue to use Libero Branch, instead of Adempiere350 branch. Done - Obsolete warning on document
  • Libero Manufacturing Manual is out of date and needs to be revised.
  • The manufacturing setup workflows are not all working correctly.
    • Bill of Materials & Formula workflow has a node UOM with wrong ID, 159 -> 50007 Cause fixed in trunk
    • Start Node still missing from one WF
    • Unsure of correct flow in WF's
  • Windows and Menu need to be tidied up.
    • Get rid of windows which are not used.
    • Remove BOMCopyFrom button, class doesn't exist in code.
    • Do we still need "Create Doc Type to Manufacturing" process? No, this process is out of date
    • Costing functionality need to be fixed. Currently working on BOM Cost Rollu Up
  • Current Adempiere_pg.dmp is not the original seed for 331b Done - Original seed replaced
    • It needs to be copied elsewhere
    • Then replaced with original Adempiere_pg.dmp for 331b
[edit]

Bugs

[ 1877863 ] Adding new bom lines fails to update LowLevel code
Adding new bom lines fails to update LowLevel code 

 When you add new bom lines, using the BOM & Formula window, the LowLevel
 code for the product is supposed to be calculated and saved to the
 M_Product.LowLevel column. This is performed using the aftersave method in MPPProductBOMLine.
 With new records the LowLevel is always being set to zero.
 If you then go back and edit the bom line, the lowlevel code is being set correctly.

[edit]

Adempiere Related Interests

  • Manufacturing Module (Victor's contribution)
  • Data Transformation (Pentaho/Kettle)
  • Bazaar / Community


[edit]

Steps Toward Creating More Contributors

Disagreements +1 / Arguments -1
Disagreements are expected in any team environment.
Arguments only make us look unprofessional and turn contributors and clients away.
Remember that we all make mistakes
After all, we are only human.
It is all part of the learning process.
Patience is a virtue
Try to assist 'newbies' in their learning process and encourage them to keep contributing.
We so easily forget we were all beginners at one point in time.
Feedback, Feedback, Feedback
When someone makes a contribution, give them feed back.
  • 'good job'
  • 'perhaps it would be better if you looked at it this way'
  • 'This article in the Wiki might help .....'
Nothing discourages a newcomer more than silence.
Constructive feedback will keep them coming back.
All contributions are priceless
Everyone comes here with different levels of experience and areas of expertise.
We also have various amounts of time available.
If we only value major contributors from the most experienced developers, then the community will slowly fade away.
Firstly because newcomers will not feel welcome and secondly because the same developers are always being left with the bulk of the workload.
Even one solitary contribution is infinitely more than no contribution at all.
[edit]

Interesting Links 

 The Cathedral and the Bazaar
Retrieved from "http://www.adempiere.com/wiki/index.php/User:Tspc"
Personal tools