not familiar with this version of ms sQl but this is a Database problem. not sure where to find it but you need to set the autogrow on you also might look at disk space.
jaiser roney sent the following on 11/17/2007 6:49 AM: > Hello, > > When i try to open entity OrderHeaderandPayment (as i used Microsoft SQL > Enterprise Manager Version: 8.0 as database ) from webtools in ofbiz i got > the following error > > javax.servlet.ServletException: javax.servlet.jsp.JspException: SQL > Exception while executing the following:SELECT OH.STATUS_ID AS STATUS_ID, > OH.ORDER_TYPE_ID AS ORDER_TYPE_ID, ORR.PARTY_ID AS PARTY_ID, > PM.PAYMENT_METHOD_TYPE_ID AS PAYMENT_METHOD_TYPE_ID, CC.PAYMENT_METHOD_ID AS > PAYMENT_METHOD_ID, CC.CARD_TYPE AS CARD_TYPE, CC.CARD_NUMBER AS CARD_NUMBER, > CC.CVV_NUMBER AS CVV_NUMBER, CC.VALID_FROM_DATE AS VALID_FROM_DATE, > CC.EXPIRE_DATE AS EXPIRE_DATE, CC.ISSUE_NUMBER AS ISSUE_NUMBER, > CC.COMPANY_NAME_ON_CARD AS COMPANY_NAME_ON_CARD, CC.TITLE_ON_CARD AS > TITLE_ON_CARD, CC.FIRST_NAME_ON_CARD AS FIRST_NAME_ON_CARD, > CC.MIDDLE_NAME_ON_CARD AS MIDDLE_NAME_ON_CARD, CC.LAST_NAME_ON_CARD AS > LAST_NAME_ON_CARD, CC.SUFFIX_ON_CARD AS SUFFIX_ON_CARD, > CC.CONTACT_MECH_IDAS CONTACT_MECH_ID, > CC.CONSECUTIVE_FAILED_AUTHS AS CONSECUTIVE_FAILED_AUTHS, > CC.LAST_FAILED_AUTH_DATE AS LAST_FAILED_AUTH_DATE, PA.TO_NAME AS TO_NAME, > PA.ATTN_NAME AS ATTN_NAME, PA.ADDRESS1 AS ADDRESS1, PA.ADDRESS2 AS ADDRESS2, > PA.DIRECTIONS AS DIRECTIONS, PA.CITY AS CITY, PA.POSTAL_CODE AS POSTAL_CODE, > PA.POSTAL_CODE_EXT AS POSTAL_CODE_EXT, PA.COUNTRY_GEO_ID AS COUNTRY_GEO_ID, > PA.STATE_PROVINCE_GEO_ID AS STATE_PROVINCE_GEO_ID, PA.COUNTY_GEO_ID AS > COUNTY_GEO_ID, PA.POSTAL_CODE_GEO_ID AS POSTAL_CODE_GEO_ID, ORR.ORDER_ID AS > ORDER_ID, ORR.ROLE_TYPE_ID AS ROLE_TYPE_ID, OH.ORDER_NAME AS ORDER_NAME, > OH.EXTERNAL_ID AS EXTERNAL_ID, OH.SALES_CHANNEL_ENUM_ID AS > SALES_CHANNEL_ENUM_ID, OH.ORDER_DATE AS ORDER_DATE, OH.ENTRY_DATE AS > ENTRY_DATE, OH.VISIT_ID AS VISIT_ID, OH.CREATED_BY AS CREATED_BY, > OH.FIRST_ATTEMPT_ORDER_ID AS FIRST_ATTEMPT_ORDER_ID, OH.CURRENCY_UOM AS > CURRENCY_UOM, OH.SYNC_STATUS_ID AS SYNC_STATUS_ID, OH.BILLING_ACCOUNT_ID AS > BILLING_ACCOUNT_ID, OH.ORIGIN_FACILITY_ID AS ORIGIN_FACILITY_ID, > OH.WEB_SITE_ID AS WEB_SITE_ID, OH.PRODUCT_STORE_ID AS PRODUCT_STORE_ID, > OH.TERMINAL_ID AS TERMINAL_ID, OH.TRANSACTION_ID AS TRANSACTION_ID, > OH.AUTO_ORDER_SHOPPING_LIST_ID AS AUTO_ORDER_SHOPPING_LIST_ID, > OH.NEEDS_INVENTORY_ISSUANCE AS NEEDS_INVENTORY_ISSUANCE, OH.IS_RUSH_ORDER AS > IS_RUSH_ORDER, OH.INTERNAL_CODE AS INTERNAL_CODE, OH.REMAINING_SUB_TOTAL AS > REMAINING_SUB_TOTAL, OH.GRAND_TOTAL AS GRAND_TOTAL, OH.PROM_TYPE AS > PROM_TYPE, OH.WEAR_DATE AS WEAR_DATE, OH.GRAD_DATE AS GRAD_DATE, > OH.LINK_SHARE_SITE_ID AS LINK_SHARE_SITE_ID, PM.GL_ACCOUNT_ID AS > GL_ACCOUNT_ID, PM.DESCRIPTION AS DESCRIPTION, PM.FROM_DATE AS FROM_DATE, > PM.THRU_DATE AS THRU_DATE, PE.SALUTATION AS SALUTATION, PE.FIRST_NAME AS > FIRST_NAME, PE.MIDDLE_NAME AS MIDDLE_NAME, PE.LAST_NAME AS LAST_NAME, > PE.PERSONAL_TITLE AS PERSONAL_TITLE, PE.SUFFIX AS SUFFIX, PE.NICKNAME AS > NICKNAME, PE.FIRST_NAME_LOCAL AS FIRST_NAME_LOCAL, PE.LAST_NAME_LOCAL AS > LAST_NAME_LOCAL, PE.MEMBER_ID AS MEMBER_ID, PE.GENDER AS GENDER, > PE.BIRTH_DATE AS BIRTH_DATE, PE.HEIGHT AS HEIGHT, PE.WEIGHT AS WEIGHT, > PE.MOTHERS_MAIDEN_NAME AS MOTHERS_MAIDEN_NAME, PE.MARITAL_STATUS AS > MARITAL_STATUS, PE.SOCIAL_SECURITY_NUMBER AS SOCIAL_SECURITY_NUMBER, > PE.PASSPORT_NUMBER AS PASSPORT_NUMBER, PE.PASSPORT_EXPIRE_DATE AS > PASSPORT_EXPIRE_DATE, PE.TOTAL_YEARS_WORK_EXPERIENCE AS > TOTAL_YEARS_WORK_EXPERIENCE, PE.COMMENTS AS COMMENTS, > PE.EMPLOYMENT_STATUS_ENUM_ID AS EMPLOYMENT_STATUS_ENUM_ID, > PE.RESIDENCE_STATUS_ENUM_ID AS RESIDENCE_STATUS_ENUM_ID, PE.OCCUPATION AS > OCCUPATION, PE.YEARS_WITH_EMPLOYER AS YEARS_WITH_EMPLOYER, > PE.MONTHS_WITH_EMPLOYER AS MONTHS_WITH_EMPLOYER, PE.DATE_OF_EVENT AS > DATE_OF_EVENT, PE.EVENT_TYPE AS EVENT_TYPE, PE.GRADUATION_YEAR AS > GRADUATION_YEAR, OCM.CONTACT_MECH_PURPOSE_TYPE_ID AS > CONTACT_MECH_PURPOSE_TYPE_ID FROM ((((dbo.PAYMENT_METHOD PM INNER JOIN > dbo.ORDER_ROLE ORR ON PM.PARTY_ID = ORR.PARTY_ID) INNER JOIN > dbo.ORDER_CONTACT_MECH OCM ON ORR.ORDER_ID = OCM.ORDER_ID) INNER JOIN > dbo.POSTAL_ADDRESS PA ON OCM.CONTACT_MECH_ID = PA.CONTACT_MECH_ID) INNER > JOIN dbo.PERSON PE ON ORR.PARTY_ID = PE.PARTY_ID) INNER JOIN > dbo.ORDER_HEADER OH ON ORR.ORDER_ID = OH.ORDER_ID, dbo.CREDIT_CARD CC (*Could > not allocate space for object 'dbo.CWT'.'CWT_PrimaryKey' in database > 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by > deleting unneeded files, dropping objects in the filegroup, adding > additional files to the filegroup, or setting autogrowth on for existing > files in the filegroup.) > * > > I wanted to ask that is the problem is related with > > 1) JVM heap size that set as low 256m high 512m > OR > 2) with the physical memory of the datase drive as my drive have a little > free space left > > are both the reasons ?? > what's the sol?? > > Please Help >
